Posted By

imbraz on 05/02/12


Tagged

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.