mysql trigger

This is about a very simply trigger but which is very useful :

syntax:

CREATE TRIGGER <trigger name> <--

{ BEFORE | AFTER }

{ INSERT | UPDATE | DELETE }

ON <table name>

FOR EACH ROW

<the sql general statement which will be triggered>

e.g:

create trigger table_insert after insert on table1 for each row insert into table2(`field`) value('value');

when you create trigger 'table_insert' like the code above , then insert a row in to table1, it also will insert a row into table2 field2=>value;

want to see you created trigger code: show triggers;

for delete trigger: drop trigger <trigger name>

note: you must have enough proviledge to create trigger , if you haven't  it will failed