MySQL

ERROR 1071 (42000) at line 25: Specified key was too long; max key length is 767 bytes 回避

投稿者:

ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
innodb_large_prefix を有効にする
mysql> set global innodb_file_format = BARRACUDA;
mysql> set global innodb_large_prefix = ON;

Thank you for reading this post, don't forget to subscribe!