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 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] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
