I know it's available since version 5.1,but :
- Is it stable?
- Is it possible to trigger event when there is insert/update operation on specific columns instead of the whole table?
views:
39answers:
2
+1
A:
- To my experience, yes, totally
- Not exclusively, but you can add a check in the body of the trigger:
IF(OLD.col <> NEW.col, ...)
Raveren
2010-01-26 14:35:10
Will operation become slow because of trigger?I mean will it wait for the trigger to finish?
2010-01-26 15:10:19
I had no noticeable performance changes since I started using it on a semi-large system. The thing you should consider most before starting to use triggers, is do you want to mix database and business logic together. I'd personally advise against it, I only used it to bring some sense into a poorly built db.
Raveren
2010-01-26 16:13:13
A:
- To my experience, yes.
- Trigger functionality is very limited. You have FOR EACH ROW option but no WHEN. It is also very limited what you can do inside the trigger. If you expect the requirements to change later (i.e. the project will go on), I would not opt to do business logic in mysql triggers. If it contains some simple check or consistency update it can do a good job.
sibidiba
2010-01-26 15:04:44