On my server, after insert on one table, I want to update two other tables. How can I do this using trigger?
Table one has two columns tab2id, tab3id.
After insert on tab1, I want to update the row in tab2 with tab2id and the row in tab3 with tab3id.
It hard to tell what exactly you want to update in tables tab2 and tab3 since you didn't elaborate on this in your question, but your trigger might look something like
DELIMITER $$ CREATE TRIGGER tg_ai_tab1 AFTER INSERT ON tab1 FOR EACH ROW BEGIN UPDATE tab2 SET value2 = value2 + 1 WHERE tab2id = NEW.tab2id; UPDATE tab3 SET value3 = value3 + 1 WHERE tab3id = NEW.tab3id; END$$ DELIMITER ; Here is SQLFiddle demo
I don't think you can INSERT and do an UPDATE at the same time using 1 SQL statement. You need to separate the executions by creating individual SQL statements. If this information is not enough, check this out. It should answer your problem completely.
