Move specified records from table to table


/ Published in: MySQL
Save to your folder(s)

Fields at Table2 must be named as those at Table1


Copy this code and paste it in your HTML
  1. INSERT INTO Table2(field1, field2, ..., fieldN) SELECT field1, field2, ..., fieldN FROM Table1 WHERE ....;
  2.  

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.