1 2 3 4 5 6 7 8 |
CREATE TABLE t1 (a varchar(40000)); ERROR 42000: Column length too big for column 'a' (max = 16383); use BLOB or TEXT instead CREATE TABLE t1 (a varchar(40000) default 'hello world'); ERROR 42000: Column length too big for column 'a' (max = 16383); use BLOB or TEXT instead CREATE TABLE t1 (a varchar(99999)); ERROR 42000: Column length too big for column 'a' (max = 16383); use BLOB or TEXT instead create table t1 (a decimal auto_increment); ERROR 42000: Incorrect column specifier for column 'a' |