weixin_45790223的博客

原创 5.6数据导入5.7的数据库时报错：index column size too large. the maximum column size is 767 bytes

mysql快速定位某个字段所在表 select * from information_schema.columns where column_name = 'C_CRCS' 5.6数据导入5.7的数据库时报错：index column size too large. the maximum column size is 767 bytes 查看MySQL 5.7的默认参数配置： mysql> SHOW VARIABLES LIKE ‘innodb_large_prefix’\G **********