|
View previous topic
::
View next topic
|
| Author |
Message |
ramon fincken
Site's programmer
Get a free globally recognized avatar
It's free!
Joined: 03 Aug 2007
Posts: 253
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(); |
|
|
| Back to top |
|
 |
Google adsense
Advertisement
|
| Posted: Thu Jan 01, 2009 8:26 pm Post subject: [snipplet] mysql5 triggers |
|
|
Advertisement
|
|
| Back to top |
|
|
|
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
|
|
|
| 
