调换student表中,两个不同ID的name属性;
UPDATE student s1 JOIN student s2
ON s1.ID='xxxx' AND s2.ID='xxxx'
SET s1.NAME=s2.NAME,s2.NAME=s1.NAME
调换student表中,两个不同ID的name属性;
UPDATE student s1 JOIN student s2
ON s1.ID='xxxx' AND s2.ID='xxxx'
SET s1.NAME=s2.NAME,s2.NAME=s1.NAME