MySQL: Copy table structure
If you need to copy the structure without data from one table to another does not necessarily make a dump of the structure and the changes it name and importing already modified dump the database. Developers MySQL all have come up for us:)
In order to create a new table that is based on the existing copy the structure of one table to another, perform command :
CREATE & lt; new_table & gt; LIKE & lt; original_table & gt;
Consider an example.
We have a table of known base TECDOC. It has the structure:
CREATE TABLE `ARTICLES` (
`ART_ID` int (11) NOT NULL,
`ART_ARTICLE_NR` varchar (66) NOT NULL,
`ART_SUP_ID` smallint (6) DEFAULT NULL,
`ART_DES_ID` int (11) DEFAULT NULL,
`ART_COMPLETE_DES_ID` int (11) DEFAULT NULL,
`ART_PACK_SELFSERVICE` smallint (6) DEFAULT NULL,
`ART_MATERIAL_MARK` smallint (6) DEFAULT NULL,
`ART_REPLACEMENT` smallint (6) DEFAULT NULL,
`ART_ACCESSORY` smallint (6) DEFAULT NULL,
`ART_BATCH_SIZE1` int (11) DEFAULT NULL,
`ART_BATCH_SIZE2` int (11) DEFAULT NULL,
`Art_url` varchar (255) NOT NULL DEFAULT ”,
`Art_url2` varchar (255) NOT NULL DEFAULT ”,
PRIMARY KEY (`ART_ID`),
KEY `ART_SUP_ID` (` ART_SUP_ID`),
KEY `ART_DES_ID` (` ART_DES_ID`),
KEY `ART_COMPLETE_DES_ID` (` ART_COMPLETE_DES_ID`),
KEY `ART_ARTICLE_NR` (` ART_ARTICLE_NR` (18))
) ENGINE = MyISAM DEFAULT CHARSET = utf8;
For the tests we need to copy the structure of the table in the table `ARTICLES_TEST`.
Execute the command:
CREATE ARTICLES LIKE ARTICLES_TEST
MySQL Server will create an identical table structure with indexes, but without the data.