mysql创建存储过程动态SQL语句DROP PROCEDURE IF EXISTS x.`wk`;
DELIMITER $$
CREATE PROCEDURE `x`.`wk`()
BEGIN
DECLARE crs VARCHAR ( 500 );
DECLARE t VARCHAR ( 50 );
SET t = CONCAT( "t_track_recording_", YEAR ( CURRENT_DATE ) );
SET crs = CONCAT( "CREATE TABLE IF NOT EXISTS ", t, " like t_track_recording; " );
SET@sql= crs;
PREPARE stmt FROM@sql;        -- 预处理动态sql语句
EXECUTE stmt ;                        -- 执⾏sql语句
mysql存储过程题目
DEALLOCATE PREPARE stmt;      -- 释放prepare
END$$
CALL `x`.`wk`()
记得⼀定要定义delimiter $$