....
BEGIN
DECLARE RsCount INT DEFAULT 0;
SET @str = CONCAT("SELECT COUNT(ID) AS CT FROM DeviceLogs WHERE DeviceID = '",
DeviceID,
"' AND Keyparam = '",
Keyparam,
"'"
);
-- SELECT @str;
PREPARE stmt FROM @str;
EXECUTE stmt;
-- SELECT RsCount;
END
如上面代码,想把字符串里的 CT的值 赋给RsCount,该如何做?
SET @str = CONCAT("SELECT COUNT(ID) INTO @RsCount FROM DeviceLogs WHERE DeviceID = '",
DeviceID,
"' AND Keyparam = '",
Keyparam,
"'"
);搞定。