https://wiki.d3xt3r01.tk//index.php?action=history&feed=atom&title=Copy_table_structureCopy table structure - Revision history2026-05-05T14:42:15ZRevision history for this page on the wikiMediaWiki 1.45.1https://wiki.d3xt3r01.tk//index.php?title=Copy_table_structure&diff=18&oldid=prevAdmin: New page: ==CODE== To copy the structure <source lang="mysql"> CREATE TABLE `newtable` LIKE `oldtable`; </source> To also copy the rows in the newtable.. <source lang="mysql"> INSERT `newtable` SEL...2009-06-25T19:46:29Z<p>New page: ==CODE== To copy the structure <source lang="mysql"> CREATE TABLE `newtable` LIKE `oldtable`; </source> To also copy the rows in the newtable.. <source lang="mysql"> INSERT `newtable` SEL...</p>
<p><b>New page</b></p><div>==CODE==<br />
To copy the structure <br />
<source lang="mysql"><br />
CREATE TABLE `newtable` LIKE `oldtable`;<br />
</source><br />
To also copy the rows in the newtable..<br />
<source lang="mysql"><br />
INSERT `newtable` SELECT * FROM `oldtable`;<br />
</source></div>Admin