Trigger on select
-
Hi, Is is possible to create a trigger ON SELECT in MySQL? If not, any other way to do it? Thanks, Jassim
Technology News @ www.JassimRahma.com
-
Hi, Is is possible to create a trigger ON SELECT in MySQL? If not, any other way to do it? Thanks, Jassim
Technology News @ www.JassimRahma.com
Jassim Rahma wrote:
Is is possible to create a trigger ON SELECT in MySQL?
Only 3 events INSERT, UPDATE & DELETE. CREATE TRIGGER Syntax[^] & its Syntax and Examples[^]
Jassim Rahma wrote:
If not, any other way to do it?
What do you want? explain clearly(ON SELECT).
thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
-
Hi, Is is possible to create a trigger ON SELECT in MySQL? If not, any other way to do it? Thanks, Jassim
Technology News @ www.JassimRahma.com
Jassim Rahma wrote:
Is is possible to create a trigger ON SELECT in MySQL?
No. That's why you added the second question, ain't it?
Jassim Rahma wrote:
If not, any other way to do it?
No. You can fetch from a SP and add that functionality yourself. Triggers aren't meant as an audit-trail, that's hardly secure.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]