Sunday, 18 August 2013

How to create a Procedure in MYSQL with only a DELETE query?

How to create a Procedure in MYSQL with only a DELETE query?

I am trying to create a MYSQL procedure that will delete a few records
based on a few conditions but I keep on getting a syntax error when I have
no SELECT statement in the procedure and only fill it with a DELETE query.
I am trying to delete records from a child table but I cant find any MYSQL
procedure that ONLY delete records.
Does anyone have any examples that you would like to share? I have been
stuck on this for a day now. Any help will be much appreciated

No comments:

Post a Comment