This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes delete multiple rows from multiple table using single stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "delete multiple rows from multiple table using single stored procedure" Watch "delete multiple rows from multiple table using single stored procedure" New topic
Author

delete multiple rows from multiple table using single stored procedure

shyamkumar bopannachengalaiah
Ranch Hand

Joined: Dec 30, 2008
Posts: 100
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.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Yes its possible. You just need to wrap your various delete statements into a procedue. What have you tried so far?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
Don't get me started about those stupid light bulbs.
 
subject: delete multiple rows from multiple table using single stored procedure
 
Similar Threads
Delete Expired Rows?
Can a PL/SQL procedure return collection ?
executeUpdate() returning unexpected results
How to return resultset from stored procdure
Calling Oracle stored procedures in JRun container