zPQaYjME

1CREATE DATABASE  my_db;                                                          
2USE my_db;
3
4CREATE TABLE IF NOT EXISTS my_table(
5     article_id INTEGER unsigned,
6     revision_ids VARCHAR(10),
7     PRIMARY KEY (article_id)
8);
9
10INSERT INTO my_table (article_id, revision_ids) VALUES (1, "154");
11	
12UPDATE my_table SET revision_ids = CONCAT((SELECT revision_ids FROM my_table WHERE article_id = 1), ", ", "999") WHERE article_id = 1;
13	
14UPDATE my_table SET revision_ids = CONCAT(revision_ids, ", ", "999") WHERE article_id = 1;
15	
16UPDATE my_table SET revision_ids = CONCAT(revision_ids, ", 999") WHERE article_id = 1;
17	
18UPDATE my_table 
19SET revision_ids = CONCAT(revision_ids, ', ', '999') 
20WHERE article_id = 1;