DROP TABLE IF EXISTS t1; CREATE TABLE t1(i INT PRIMARY KEY) ENGINE=innodb; CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN END; ALTER TABLE t1 ADD COLUMN j INT; DROP TRIGGER tr1; CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN END;