1709 - Index column size too large. The maximum column size is 767 bytes.
說明
注:以 utf8mb4 字符集
字串
型別欄位為例。utf8mb4 是 4 位元組字符集,預設支援的索引欄位最大長度是 191 字元(767 位元組 / 4 位元組每字元 ≈ 191 字元),因此在
varchar(255)
或
char(255)
型別欄位上建立索引會失敗。
建表前新增語句
set global innodb_large_prefix = 1;
set global innodb_file_per_table = 1;
set global innodb_file_format = Barracuda;
ROW_FORMAT = DYNAMIC
參考博文:
https://blog.csdn.net/kjrim/article/details/115141343
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/69949806/viewspace-2923034/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Err] 1709 - Index column size too large. The maximum column size is 767 bytes.Index
- Index column size too large. The maximum column size is 767 bytes.Index
- mysql specified key was too long與Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- mysql5.7 資料匯入5.6 Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- MySQL建立表失敗:Index column size too large. The maximum column size is 767 bytesMySqlIndex
- MySQL 5.7 到 5.6,出現 Index column size too large. The maximum column size is 767 bytesMySqlIndex
- MySQL資料庫index column size too large. the maximum column size is 767 bytes問題解決MySql資料庫Index
- mysql Index column size too large 超過767錯誤解決方案(轉)MySqlIndex
- #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs
- data too long for column
- ORA-12899: value too large for column ORG_NAME (actual: 145, maximum: 128)
- Bug 31625618 DML Over a LOB Column ORA-3137 [3146]When the Bind Size is > 256k
- Row size too large (> 8126)解決辦法
- java.lang.IndexOutOfBoundsException: Index: 0, Size: 0JavaIndexException
- Unhandled rejection RangeError: Maximum call stack size exceededill install loadIdealTreeErrorIdea
- ORA-01144: File size (4224000 blocks) exceeds maximum of 4194303BloC
- ProTable 報錯Uncaught RangeError: Maximum call stack size exceededError
- Mysql 報Row size too large 65535解決方法MySql
- [20180608]Wrong Results with IOT, Added Column and Secondary Index.txtIndex
- js中Uncaught RangeError: Maximum call stack size exceeded錯誤JSError
- [20180609]Wrong Results with IOT, Added Column and Secondary Index2.txtIndex
- 修改SharePoint上傳檔案大小限制(Changing Maximum Upload Size)
- 關於錯誤訊息 RangeError - Maximum call stack size exceeded at XXXError
- OGG-01163 Bad column length (32) specified for column in table
- Vue專案中出現:Maximum call stack size exceeded(堆疊溢位)Vue
- iis 0x80070032 Cannot read configuration file because it exceeds the maximum file size
- [20200904]12c invisible column impdp segment_column_id.txt
- Sorting arrays in NumPy by column
- CSS column-gapCSS
- CSS column-ruleCSS
- CSS column-widthCSS
- CSS column-spanCSS
- 5.6.7. Renaming a Column
- gitignore by file size?Git
- height_scale = scales[2] IndexError: index 2 is out of bounds for axis 0 with size 0IndexError
- ExtJs的Column佈局JS
- alter table set unused column
- Map size 屬性