Trigger an insert upon insert/update

Question

Hi I have never used a trigger before and i am confused about the syntax. My program uses mysql and the tables i want to interact with are 'orders' and 'updates' What I want is for whenever the orders table has an update or insert to the column called 'orderType' it will insert into the updates table column 'type' a value that matches the inserted/updated a value that matches the new ordertype and has a timestamp for the second value. Please let me know if I am not being clear enough I have never used triggers before.

Jignesh Trivedi · Answer

hi for creating trigger with mysql please refer.... http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html http://www.roseindia.net/mysql/mysql5/triggers.shtml i am clear from which column updated in insert opration. please clerify it. thx hope this will help you.

patrick · Answer

Hi I realized i was being silly and didn't need a trigger i used timestamps in the same table as ALTER TABLE orders ADD lastmodified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;