Re: Execute 3 Queries in Single Command

if you are using MySQL 5 you could use a stored procedure On 7/27/07, Samrat Kar <[EMAIL PROTECTED]> wrote: > > I want to execute three sql statements in single query which will perform > following task... > 1. select a particular row > 2. insert that row to another table > 3. delete that row from

Execute 3 Queries in Single Command

I want to execute three sql statements in single query which will perform following task... 1. select a particular row 2. insert that row to another table 3. delete that row from 1st table in short, i want to move one row from table 1 to table 2 with single query.. thanks in advance for any sug