More than 5 years have passed since last update.

mysqlerror: (1071, 'Specified key was too long; max key length is 767 bytes').

MySQL

Last updated at 2017-03-14Posted at 2017-03-14

SET GLOBAL innodb_file_per_table = ON,
           innodb_file_format = Barracuda,
           innodb_large_prefix = ON;
CREATE/ALTER TABLE ...
    ROW_FORMAT = DYNAMIC or COMPRESSED

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up