Error instrucción ALter Table en trigger (1 reply)
(MySQL.com) Hola a todos,
Estoy haciendo un sencillo trigger como este:
CREATE TRIGGER ....
FOR EACH ROW BEGIN
if new.campo1> 'buscar' then
alter table tabla1 add campo2 varchar(255) NOT NULL;
end if;
end
Y me da el siguiente error
#1422
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:09:11
