Q 40. How to copy tables in SQL?
Ans : Sometimes, in SQL, we need to create an exact copy of an already defined (or created) table. MySQL enables you to perform this operation. Because we may need such duplicate tables for testing the data without having any impact on the original table and the data stored in it.
CREATE TABLE Contact List(Clone_1) LIKE Original_table;
No comments:
Post a Comment