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?