MySQL 同一张表,两个字段互换值
标签：code color pre where family style mil port col
MySQL 同一张表,两个字段互换值
t_hplc_family_import a, t_hplc_family_import b
set
a.f_name= b.f_num, a.f_num= b.f_name
where a.id = b.id
AND a.id>=498