-- 创建一个表名长度在限制内的表 CREATE TABLE short_table_name ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) ); -- 尝试创建一个表名过长的表(会失败) CREATE TABLE this_is_a_very_long_table_name_that_exceeds_the_maximum_length_allowed_by_mysql ( id INT AUTO_INCREMENT PRIMARY ...
例如:mysql> CREATE TABLE t (a VARCHAR(8000), b VARCHAR(10000), -> c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), -> f VARCHAR(10000), g VARCHAR(10000)) ENGINE=InnoDB; ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BL...
Identifier Maximum Length (characters) Database 64 (NDB storage engine: 63) Table 64 (NDB storage engine: 63) Column 64 Index 64 Constraint 64 Stored Program 64 View 64 Tablespace 64 Server 64 Log File Group 64 Alias 256 (see exception following table) Compound Statement Label 16 Oracle官方...
CHARACTER_MAXIMUM_LENGTH * 4 + IF(CHARACTER_MAXIMUM_LENGTH <= 255, 1, 2)) -- 对于字符串类型,假设UTF-8编码,实际长度需根据字符集确定 WHEN DATA_TYPE IN ('date', 'time') THEN 3 WHEN DATA_TYPE IN ('datetime', 'timestamp') THEN 5 + IFNULL(DATETIME_PRECISION, 0) WHEN DATA_TYPE =...
mysql_prepare_create_table /* sql/sql_table.cc:3474 */ --> mysql_create_frm /* sql/unireg.cc:107 */ --> pack_header /* sql/unireg.cc:733 */ 在pack_header中存在这部分代码: if (reclength > (ulong) file->max_record_length()) /* 右值为 65535 */ ...
Aliases for column names inCREATE VIEWstatements are checked against the maximum column length of 64 characters (not the maximum alias length of 256 characters). Identifiers are stored using Unicode (UTF-8). This applies to identifiers in table definitions that are stored in.frmfiles and to iden...
mysql_prepare_create_table /* sql/sql_table.cc:3474 */ --> mysql_create_frm /* sql/unireg.cc:107 */ --> pack_header /* sql/unireg.cc:733 */ 在pack_header中存在这部分代码: if (reclength > (ulong) file->max_record_length()) /* 右值为 65535 */ ...
(rec_max_size>=page_rec_max){ib::error_or_warn(strict)<<"Cannot add field "<<field->name<<" in table "<<table->name<<" because after adding it, the row size is "<<rec_max_size<<" which is greater than maximum allowed"" size ("<<page_rec_max<<") for a record on index...
1.mysql_prepare_create_table /* sql/sql_table.cc:3474 */ 2. 3. 在pack_header中存在这部分代码:1.if (reclength > (ulong) file->max_record_length()) /* 右值为 65535 */ 2.{ 3.my_error(ER_TOO_BIG_ROWSIZE, /* 这个就是上面的报错信息对应的状态值 */ 4.MYF(0), 5....
If the pointer size is too small for an existing table, you can change the options withALTER TABLEto increase a table's maximum permissible size. SeeALTER TABLE Statement. ALTERTABLEtbl_nameMAX_ROWS=1000000000AVG_ROW_LENGTH=nnn; You have to specifyAVG_ROW_LENGTHonly for tables withBLOBorTEXT...