Show pageOld revisionsBacklinksExport to PDFBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== Duplicate table and data in MySql ====== Use the following SQL code to duplicate table structure: <code>CREATE TABLE newtable LIKE oldtable;</code> And if you need the same data in the new table (for testing?), copy the data with this SQL code: <code>INSERT INTO newtable SELECT * FROM oldtable;</code> database/mysql/duplicate_table_and_data.txt Last modified: 2019/10/31 09:04by 127.0.0.1