如题,我想每隔数分钟建立一张表,请问如下代码哪里有问题,能执行不报错,但是不能成功建表,
如果有问题,能否帮忙写一段更好的处理方式?
create EVENT createMtpulseTable
ON SCHEDULE every 3 minute
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(NOW(),'%H%i'),'(id INT not NULL auto_increment,PRIMARY KEY(id));');
SET @sqlstr=str;
PREPARE stmt from @sqlstr;
EXECUTE stmt;
deallocate prepare stmt;
END;