UPDATE contact t1,contact t2 SET t1.first_name=t1.last_name,t2.last_name=t2.first_name
一看就懂
UPDATE contact t1,contact t2 SET t1.first_name=t1.last_name,t2.last_name=t2.first_name
UPDATE contact t1,contact t2 SET t1.first_name=t1.last_name,t2.last_name=t2.first_name
转载于:https://my.oschina.net/liangzh/blog/294457