Untitled
public sql v1 · immutableINSERT INTO meta2_neighbours (frommeaning, tomeaning, meta2_neighbours.conflict, meta2_neighbours.level) SELECT newmeaning as frommeaning, tomeaning, m2.conflict, m2.level FROM meta2_neighbours m2 JOIN meta2_tmp_alias ON oldmeaning = frommeaning ON DUPLICATE KEY UPDATE level = IF(m2.level < VALUES(level), m2.level, VALUES(level)), conflict = IF(m2.conflict > VALUES(conflict), m2.conflict, VALUES(conflict)) ;