有一个原因为什么不能使用存储过程来创建准备好的语句?
DELIMITER //DROp PROCEDURE IF EXISTS rand_quote//CREATE PROCEDURE rand_quote()BEGIN SET @rand := ROUND((SELECT COUNT(*) FROM quotes) * RAND()); SET @sql := CONCAt('SELECt * FROM quotes LIMIT ', @rand, ', 1'); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;END;//DELIMITER ;


