Some time when you need to genrate a duplicate copy of a table by a single query then here is a simple query to fulfill your requirement.
Query :
create table table_name as select * from source_table
Example : Take the below example table
Table_name : tbl_user
+-----+--------+---------------+
| id | name | salery |
+-----+--------+---------------+
| 301 | salman |
16000 |
| 302 | shahrukh|
10000 |
| 303 | amir |
8000 |
+-----+--------+---------------+
Now i want to create a backup or copy of the above tbl_user table with name tbl_user_bkup.So query is like below :
Query :
create table tbl_user_bkup as select * from tbl_user
Output :
Table_name : tbl_user_bkup
+-----+--------+---------------+
| id | name | salery |
+-----+--------+---------------+
| 301 | salman |
16000 |
| 302 | shahrukh|
10000 |
| 303 | amir |
8000 |
+-----+--------+---------------+
If you like this post please don't forgot to post a comment.
Happy coding Guys :)
