mysql insert trigger

Solutions on MaxInterview for mysql insert trigger by the best coders in the world

Search
showing results for - "mysql insert trigger"
Leonardo
09 Jun 2018
1DELIMITER //
2
3CREATE TRIGGER contacts_after_insert
4AFTER INSERT
5   ON contacts FOR EACH ROW
6BEGIN
7   -- Insert record into audit table
8   INSERT INTO contacts_audit
9   ( contact_id,
10     created_date,
11     created_by)
12   VALUES
13   ( NEW.contact_id,
14     SYSDATE(),
15     "Admin" );
16END; //
17
18DELIMITER ;
source
similar questions
sql triggersql triggermysql desactivar triggermssql triggermysql create triggercreate trigger sqltrigger in mysqltrigger before insert sql codemysql trigger exampletrigger before insertt sql create triggeroracle sql trigger after insertsql trigger after insertmysql triggersmysql edit triggerhow use trigger in sqlmssql trigger examplescreate trigger in phpmyadmintrigger insertmysql trigger after updateinsert after update triggermysql drop triggersql trigger examplehow to set up a trigger in sqlmysql batch insertinsert into mysql subquerytrigger in mysql syntax
queries leading to this page
mysql after insert triggercreate trigger mysql before inserttrigger insert in mysqlafter insert trigger mysqlmysql add trigger on insertmysql before insert trigger examplemysql trigger after insert mysql trigger insertcreate a trigger before insert in mysqlmysql trigger after inserthow to create trigger before insert in mysqlmysql create trigger after insert frommysql new keyword after insert triggermysql trigger on insertbefore insert trigger mysqlhow to create trigger after insert in mysqlmysql trigger before inserttrigger after insert mysqlon insert trigger mysqladd trigger in mysqlhow to call trigger on insert in mysqlcreate insert trigger mysqlinsert into trigger mysqlmysql insert trigger examplehow to create after insert trigger in mysqlcreate trigger in mysql after inserttrigger in mysql after insertmysql insert trigger