A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to. This MySQL tutorial explains how to create an AFTER INSERT Trigger in MySQL with syntax and examples. An AFTER INSERT Trigger means that MySQL will. As far as I can tell both triggers are OK, but you might try the following: DELIMITER $$ CREATE TRIGGER count_delete_videos BEFORE DELETE ON videos.
|Published (Last):||6 June 2016|
|PDF File Size:||14.34 Mb|
|ePub File Size:||15.10 Mb|
|Price:||Free* [*Free Regsitration Required]|
Disparadores, Funciones y Procedimientos by Ernesto Robles on Prezi
Here is what I have: But yet, when I try to insert into users: No data – zero rows fetched, selected, or processed Do you have any idea?
Or better, do you know how I can get a better error message? Arthur 2, 5 20 Take a look here: I had another error with this script: Not allowed to return a result set from a trigger. But then, it still doesn’t work.
If you want to help me, I’ve edited my post. I’ve updated my post. Sign up or log in Sign up using Google.
Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.