Move specified records from table to table - MySQL Snipplr Social Repository

Revision: 55916

at February 29, 2012 05:20 by kossmoss

Updated Code

INSERT INTO Table2(field1, field2, ..., fieldN) SELECT field1, field2, ..., fieldN FROM Table1 WHERE ....;

DELETE FROM Table WHERE ....;

Revision: 55915

at February 29, 2012 05:18 by kossmoss

Initial Code

INSERT INTO Table2(field1, field2, ..., fieldN) SELECT field1, field2, ..., fieldN FROM Table1 WHERE ....;

DELETE FROM T1 WHERE ....;

Initial URL

http://www.mysql.ru/webboard/index.html?n1=5843&n2=2

Initial Description

Fields at Table2 must be named as those at Table1

Initial Title

Move specified records from table to table

Initial Tags

Initial Language

MySQL