Question

mysql 存储过程中怎么执行sql语句？？？

prepare stmt from sqlstr;
execute stmt;
为什么这样不行？？

Answer 1

SET @update_stmt='' /*在单引号中间填入要执行的sql语句*/
PREPARE stmt FROM @update_stmt;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

Answer 2

他说的对

Answer 3

应该是执行存储过程