A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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?
I agree. Here's the link:
subject: delete multiple rows from multiple table using single stored procedure
executeUpdate() returning unexpected results
Can a PL/SQL procedure return collection ?
Calling Oracle stored procedures in JRun container
How to return resultset from stored procdure
Delete Expired Rows?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015