对于一个存储过程,我想要进行SELECT操作,并将一列的值存储到一个变量中。
我该如何做呢?
我想要做类似这样的操作:
DECLARE countTemp INT;
SET countTemp=(SELECT COUNT(Name) FROM mytable WHERE Name= var_name LIMIT 0,1);
或者,像这样:
或者这样:
DECLARE countTemp INT;
SELECT countTemp=ColumnXYZ FROM mytable WHERE Name= var_name LIMIT 0,1;
但是,我尝试了这些方法,MySQL说我的语法不正确;我应该怎么做才能做到这一点?
Script line: <#> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE countTemp INT; SET countTemp=SELECT COUNT(Name) FROM myTa' at line <#>
- rlb.usa