BEGIN DECLARE AID INT; DECLARE RSCOUNT VARCHAR(45);
SELECT id,COUNT(id) INTO AID,RSCOUNT FROM X WHERE type = 2 IF (RSCOUNT = 0) THEN SELECT * FROM X End IF; END例如上面代码,当使用了INTO后就不返回第一个SELECT的结果集,如何才能获得COUNT(id)值的同时返回第一个SELECT的结果集?
SELECT aid:= id,rscount:=COUNT(id) FROM X WHERE type = 2
ERROR 1064: 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 ':=ID FROM city;END' at line 4上面的语法好像不对呀?机器上是windows下的最新版本的mysql
FROM X
WHERE type = 2