MySql如何在更新语句中设置局部变量(语法?) [英] MySql How to set a local variable in an update statement (Syntax?)

问题描述

在执行Update语句时如何设置变量?我似乎无法弄清楚语法.

How can I set a variable while doing an Update statement? I can't seem to figure out the syntax.

所以我在下面想要这样的东西，但这是在说语法错误:

So I want something like this below but it's saying the syntax is wrong:

SET @tempVariable := 0;
UPDATE myTable SET col1 = 5, col2 = @tempVariable, @tempVariable := 100;

推荐答案

这是可能的:-

 UPDATE myTable SET col1 = 5,
 col2 = (@tempVariable:=@tempVariable+1) // to increment

设置整数(不递增)

 UPDATE myTable SET col1 = 5, 
 col2 = (@tempVariable:=100) // to assign any integer

这篇关于MySql如何在更新语句中设置局部变量(语法?)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！