Advanced Search

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

Expand | Embed | Plain Text

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

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.