Re: primary key limit

[Chris Stubben]

I think in 4.1 you can store up to 1000 characters on myisam tables... Probably not a good idea.

Chris

create table tmp(a text NOT NULL, primary key(a(1000)));
Query OK, 0 rows affected (0.01 sec)

create table tmp(a text NOT NULL, primary key(a(1001)));
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

see also

http://dev.mysql.com/doc/mysql/en/indexes.html