Question

This should be a simple syntax thing: I m trying to set a variable in MySQL equal to the result of a query for instance:

SET @variable1 = SELECT salary FROM employee_info WHERE emp_id = 12345678;

基本上,我希望把雇员的工资储存起来,作为一个变量然后我就可以操纵和添加。

正确的语法会是什么因为我不能让它工作。

Answer 1

SELECT salary INTO @variable1 FROM employee_info WHERE emp_id = 12345678 LIMIT 1;

或

SET @variable1 = (SELECT salary FROM employee_info WHERE emp_id = 12345678 LIMIT 1);

SELECT @variable1;

Answer 2

您甚至可以在单个查询中填入多个变量。

SELECT salary, salary_group INTO @var1, @var2 FROM employee_info WHERE emp_id = 12345678;

Answer 3

你非常接近正确的语法。这里是:

SET @variable1 = (SELECT salary FROM employee_info WHERE emp_id = 12345678);

然后像这样打印变量 :

SELECT @variable1;

Answer 4

< 加强> 设置查询结果到 MySQL 中的变量

Select  @Amount1:=  Amount FROM table where id=57703;

Answer 5

SELECT @code:=salary FROM employee_info WHERE emp_id = 12345678;

检查工资

SELECT @code;

薪金结果将在 code 中初始化。

Answer 6

使用此

SELECT weight INTO @x FROM p_status where tcount=[ value ] LIMIT 1;

测试和工作良好...

Answer 7

select @variable1 := salary FROM employee_info WHERE emp_id = 12345678;