see the example how to swap column rows value
UPDATE emprs SET EName=(@temp:=EName), EName= Salary, Salary = @temp;
or
UPDATE emprs s1, emprs s2 SET s1.EName=s1.Salary, s1.Salary=s2.EName WHERE s1.id=s2.id;
UPDATE emprs SET EName=(@temp:=EName), EName= Salary, Salary = @temp;
or
UPDATE emprs s1, emprs s2 SET s1.EName=s1.Salary, s1.Salary=s2.EName WHERE s1.id=s2.id;
No comments:
Post a Comment