Kattle mysql表迁移 mysql工具迁移

### 具体操作见其他文章

https://www.cnblogs.com/gina11/p/14335433.html

### 釆坑  整体流程

1. 手动导出表结构，手动导入创建表

2. 查询所有外键语句，保留创建语句

select  CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' ADD constraint `',CONSTRAINT_NAME,'`  FOREIGN KEY (`',COLUMN_NAME,'`) references ',REFERENCED_TABLE_NAME,'(`',REFERENCED_COLUMN_NAME,'`)  ;') 
from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA ='LA' and CONSTRAINT_NAME <>"PRIMARY"

3. 删除所有外键

SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' DROP FOREIGN KEY ',CONSTRAINT_NAME,' ;') 
FROM information_schema.TABLE_CONSTRAINTS c 
WHERE c.TABLE_SCHEMA='LA' AND c.CONSTRAINT_TYPE='FOREIGN KEY';

4. 运行教程内容平移表  完成后，  执行2中的创建外键语句