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 suggestion


-------------------------------------------------


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to