Mysql同步数据库异常
1709 - Index column size too large. The maximum column size is 767 bytes.
建表前添加语句
set global innodb_large_prefix = 1;
set global innodb_file_per_table = 1;
set global innodb_file_format = Barracuda;
1217 - Cannot delete or update a parent row: a foreign key constraint fails
原因是Foreign Key的约束
关闭Foreign Key检查
Set FOREIGN_KEY_CHECKS = 0;
恢复Foreign Key检查
Set FOREIGN_KEY_CHECKS = 1;