dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

procedure can not create multi statement - mysql

This is a discussion on procedure can not create multi statement - mysql ; Dear i had one question relate to create multi statement in on procedure statement like this Create procedure deleterelatedata() delete from atable, delete from btable, delete from ctable; but the statement cannot be done by this script...


Home > Database Forum > Other Databases > mysql > procedure can not create multi statement

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 08-31-2009, 04:42 AM
Database Newbie
 
Join Date: Aug 2009
Posts: 1
roger5089 is on a distinguished road
Default procedure can not create multi statement

Dear

i had one question relate to create multi statement in on procedure
statement like this

Create procedure deleterelatedata()
delete from atable,
delete from btable,
delete from ctable;

but the statement cannot be done by this script
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
dump without "security definer" for views? Database Administrator mysql 8 08-15-2008 09:45 AM
Re: [SQL] rule for update view that updates/inserts into 2 tables Database Administrator postgresql 0 04-15-2008 11:28 AM
Help with stored procedure Database Administrator ibm-db2 0 01-10-2008 09:24 AM
Re: Temp table in Procedure Database Administrator Oracle Server 0 04-05-2004 05:35 PM


All times are GMT -4. The time now is 05:07 AM.