Posted By

imbraz on 05/02/12

Tagged

Viewed 702 times

Favorited by 0 user(s)

/ Published in: MySQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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

Comment:

You need to login to post a comment.