Syntax to copy one existent MySQL table from one database to another database:
|
1 |
CREATE TABLE `new_database`.`table` SELECT * FROM `old_database`.`table`; |
Syntax to copy one existent MySQL table to another table in the same database:
|
1 |
CREATE TABLE `database`.`table` SELECT * FROM `database`.`table`; |
That’s it.
I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.
I am Arjun from Hyderabad (India). I have been working as a software engineer from the last 7+ years, and it is my passion to learn new things and implement them as a practice. Aside from work, I like gardening and spending time with pets.
Subscribe
Login
0 Comments
