Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
delete multiple rows from multiple table using single stored procedure
Joined: Dec 30, 2008
Jan 20, 2009 03:42:02
i have a doubt that is it possible to delete multiple rows from multiple tables with in a single procedure.if yes, can anyone give some idea how to do in a stored procedure in mysql.
Joined: Apr 14, 2004
Jan 20, 2009 03:59:30
Yes its possible. You just need to wrap your various delete statements into a procedue. What have you tried so far?
It is sorta covered in the
JavaRanch Style Guide
subject: delete multiple rows from multiple table using single stored procedure
How to return resultset from stored procdure
Calling Oracle stored procedures in JRun container
Delete Expired Rows?
Can a PL/SQL procedure return collection ?
executeUpdate() returning unexpected results
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013