Monday, 15 September 2014

MySQL is it possible to merge on insert? -



MySQL is it possible to merge on insert? -

i have column coma separated id list. if script trying insert existing row i'd merge lists instead. possible sql? here insert script:

insert film ( title, subtitle, year, filmids, masterids ) (select originaltitel, originaluntertitel, entstehungsjahr, group_concat(filmid), group_concat(master_id) cinema originaltitel not null grouping originaltitel ) union (select titel, untertitel, entstehungsjahr,group_concat(filmid), group_concat(master_id) cinema originaltitel null grouping originaltitel )

mysql insert group-concat

No comments:

Post a Comment