mysql prepare in方法_存储过程中的MySQL PREPARE语句

我有这个sql文件：

USE mydb;

DROP PROCEDURE IF EXISTS execSql;

DELIMITER //

CREATE PROCEDURE execSql (

IN sqlq VARCHAR(5000)

) COMMENT 'Executes the statement'

BEGIN

PREPARE stmt FROM sqlq;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

END //

DELIMITER ;

当我尝试运行它时

#cat file.sql | mysql -p

我明白了

ERROR 1064 (42000) at line 6: 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 'sqlq;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

END' at line 5

我究竟做错了什么？

解决方法:

您只能准备和执行sql,它是一个字符串文字或包含该语句文本的用户变量.尝试

USE mydb;

DROP PROCEDURE IF EXISTS execSql;

DELIMITER //

CREATE PROCEDURE execSql (

IN sqlq VARCHAR(5000)

) COMMENT 'Executes the statement'

BEGIN

SET @sqlv=sqlq;

PREPARE stmt FROM @sqlv;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

END //

DELIMITER ;

标签：mysql,stored-procedures,prepare

来源： https://codeday.me/bug/20190712/1438267.html