Full Text Search: The Key to Better Natural Language Queries for NoSQL in Node.js

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

CREATE TABLE new_table LIKE _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


Source link
thanks you RSS link
( http://www.devx.com/DevX/tip-create-a-table-from-an-existing-table-in-mysql.html)


Please enter your comment!
Please enter your name here