这个有可能 :-
UPDATE myTable SET col1 = 5,
col2 = (@tempVariable:=@tempVariable+1) // to increment
设置整数(不递增)
UPDATE myTable SET col1 = 5,
col2 = (@tempVariable:=100) // to assign any integer
MySql如何在更新语句中设置局部变量(语法?)
这个有可能 :-
UPDATE myTable SET col1 = 5,
col2 = (@tempVariable:=@tempVariable+1) // to increment
设置整数(不递增)
UPDATE myTable SET col1 = 5,
col2 = (@tempVariable:=100) // to assign any integer