| 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
|
|
 |
|
|
subject: delete multiple rows from multiple table using single stored procedure
|
|
|
0
