Joined: 03 Aug 2007 Posts: 412 Location: A'dam/Diemen, The Netherlands
Posted: Thu Jan 01, 2009 8:26 pm Post subject: [snipplet] mysql5 triggers
Triggers are great stuff when using mysql5
You can auto update foreign tables having a relationship like this:
table: products
id, cat_id, name, price
tabel: cats
id, name, parent_id
When using triggers you can auto update the FK cat_id on the products table.
I let that to be up to you for now while I give you two simple queries to make sure a date field ( datum, DATE, NULL ) is allways up to date with the latest INSERT or UPDATE:
( I think these lines of code speak for themselves ... )
Code:
CREATE TRIGGER `coupon_code_update` BEFORE UPDATE ON `coupon_code`
FOR EACH ROW SET NEW.datum = now();
CREATE TRIGGER `coupon_code_insert` BEFORE INSERT ON `coupon_code`
FOR EACH ROW SET NEW.datum = now();
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum