![]() query.įor example, suppose you have a table named customer and you need to create a copy of it called customer_clone table. If you want to create a shallow clone table that only has the original table column attributes and data, you can use the CREATE TABLE. This tutorial will show you how to use all the methods above to copy a MySQL table. SHOW CREATE TABLE query to create an identical copy of the original table.AS query to copy the table column attributes and data Since MySQL doesn’t have a copy table statement, you need to create a work-around query when you want to copy an existing MySQL database table as a new table.ĭepending on how identical the copy table is to the original table you want to be, there are three easy ways you can copy a table: Three easy ways to create a copy of MySQL table (example query included)
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |