当前位置:首页 > 数据库 > 正文

mysql的动态表名

2024-03-31 数据库

  1. 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