CREATE TRIGGER testTrigger BEFORE INSERT ON tbl_table1 FOR EACH ROW BEGIN INSERT INTO tbl_table2 (id,name) values (NEW.id,NEW.name); END