Create new column in event based on query

0

I want to create a new column every 28th of every month, the problem is that I want it to have a specific name based on a query. This is what I have:

CREATE DEFINER='root'@'localhost' EVENT 'evento_mes'
    ON SCHEDULE
    EVERY 1 MONTH STARTS '2016-11-28 01:00:00'
    ON COMPLETION PRESERVE
    ENABLE
    COMMENT 'Crea nueva tabla'
    DO 
    BEGIN
      ALTER TABLE 'table'
      ADD COLUMN SELECT CONCAT('_',MONTH(NOW()) + 3,'_',YEAR(NOW())+1) 
      VARCHAR(70) 
      NULL DEFAULT NULL;
    END

Is it possible to do what I am proposing?

    
asked by Alberto Siurob 24.11.2016 в 17:55
source

0 answers