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;
温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/13654.html
- 上一篇:mysql-API
- 下一篇:java中使用jdbc连接数据库操作