mysql出现 Specified key was too long; max key length is 1000 bytes

往MySQL导入数据时遇到

  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes

解决方法:

  修改mysql默认存储引擎

修改mysql配置文件

default-storage-engine=INNODB 

 

posted @ 2021-01-15 14:27  慕尘  阅读(123)  评论(0编辑  收藏  举报