Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Create a Table from an Existing Table in MySQL

Learn how to easily create a new table that includes the indexes of the source table.


advertisement

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


MySQL provides a command named LIKE that can be used in CREATE TABLE command. This is most useful when you want to create a new table along with the indexes of the source table.

CREATE TABLE new_table LIKE existing_table

The LIKE command will replicate the existing_table structure to the new_table along with the indexes as well.

Note: Foreign keys will not be copied.

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date