mysql: перемещение записи в другую таблицу
INSERT INTO table1 (field1,field2) SELECT field1,field2 FROM table2 WHERE id='1'; DELETE FROM table1 WHERE id='1';
INSERT INTO table1 (field1,field2) SELECT field1,field2 FROM table2 WHERE id='1'; DELETE FROM table1 WHERE id='1';