mysql的动态表名

时间:2022-01-29 03:15:20

  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;