You Are Here Home > Copy An Entire Table – Data & Structure
DirectorySync is a directory synchronizing and backup utility providing automated, real-time syncing and scheduled, configurable backups at an affordable price.

Copy An Entire Table – Data & Structure

Assume that we want to copy our ‘user’ table to a table called ‘backup’:

CREATE TABLE backup LIKE user;
INSERT INTO backup SELECT * FROM user;
Copy An Entire Table – Data & Structure
Filed under: MySQL   Posted by: Codehead
Do you have any questions? ask here.




No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment