当前位置：网站首页>MySQL replication table

MySQL replication table

2022-07-19 03:03:00 【xiejunna】

This want to use Create table Table2 (Select * from Table1); This statement , But it turns out , No problem with data copying , But in the table structure primary key,Extra,auto_increment And other properties are gone , Only give up this method .

Using this method ：

// Show table creation statement , Copy the table creation statement , Change the table name to the table name of the new table , Create table 
SHOW CREATE TABLE `ori_table`;

// Copy the data of the original table to the new table 
INSERT INTO `new_table` SELECT * FROM `ori_table`;