mysql创建新的表,mysql 每个月创建新表

1、

CREATE DEFINER=`root`@`%` PROCEDURE `aa`()

BEGIN

SET @sqlstr = CONCAT('create table cdrpbx10_',DATE_FORMAT(CURDATE(),'%Y%m'),' like cdrpbx10');

PREPARE stmt1 FROM @sqlstr ;

EXECUTE stmt1 ;

SET @sqlstr = CONCAT('insert into cdrpbx10_',DATE_FORMAT(CURDATE(),'%Y%m'),' select * from cdrpbx10');

PREPARE stmt1 FROM @sqlstr ;

EXECUTE stmt1 ;

END

2、

CREATE EVENT IF NOT EXISTS eventJob

#ON SCHEDULE EVERY 1 SECOND 每秒执行一次定时任务

ON SCHEDULE EVERY 1 MONTH STARTS '2019-04-01 11:08:53'

ON COMPLETION PRESERVE

DO CALL aa();

3、

SET GLOBAL event_scheduler = 1; 1开启定时任务 0关闭定时任务

标签：aa,SET,创建,stmt1,cdrpbx10,mysql,新表,定时,sqlstr

来源： https://www.cnblogs.com/xdcr/p/10641603.html