Posted By

imbraz on 05/02/12


mysql copy

Versions (?)

Copy an SQL Table

 / Published in: MySQL

Create a new table from the details of another table then insert the table contents

  1. CREATE TABLE schema.NEWTable LIKE schema.OLDTable;
  2. INSERT schema.NEWTable SELECT * FROM schema.OLDTable;

Report this snippet  

You need to login to post a comment.