SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE `test1` ( `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `content` TEXT NOT NULL ) ENGINE = MYISAM; CREATE TABLE `log1` ( `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `msg` VARCHAR( 255 ) NOT NULL, `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `row_id` INT( 11 ) NOT NULL ) ENGINE = MYISAM; CREATE TRIGGER `update_test` AFTER INSERT ON `test1` FOR EACH ROW BEGIN INSERT INTO log1 Set msg = 'insert', row_id = NEW.id; END;