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;
Home
>
Copy An Entire Table – Data & Structure Copy An Entire Table – Data & Structure
About Me
RSS Feed
I'm the co-founder of
No comments yet.
RSS feed for comments on this post. TrackBack URL