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