All pastes #82507 Raw Edit

Untitled

public sql v1 · immutable
·published 2006-07-08 16:26 UTC
rendered paste body
INSERT 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)) ;