mysql的动态表名

create EVENT createMtpulseTable
ON SCHEDULE every 1 month 
STARTS CURRENT_TIMESTAMP
DO
CALL pro_createTable();

CREATE PROCEDURE pro_createTable()
BEGIN
DECLARE str VARCHAR(500);
-- set @str='create table';
set str= CONCAT('create table mtpulse',DATE_FORMAT(CURRENT_DATE(),'%Y%m'),'(id INT not NULL  auto_increment,PRIMARY KEY(id))');
SET @sqlstr=str;
PREPARE stmt from @sqlstr;
EXECUTE stmt;
deallocate prepare stmt;
END;