Posted By

kossmoss on 02/29/12


Tagged


Versions (?)

Move specified records from table to table


 / Published in: MySQL
 

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

Fields at Table2 must be named as those at Table1

  1. INSERT INTO Table2(field1, field2, ..., fieldN) SELECT field1, field2, ..., fieldN FROM Table1 WHERE ....;
  2.  
  3. DELETE FROM Table WHERE ....;

Report this snippet  

You need to login to post a comment.