Hi
I'm new to MySql and I'm trying to set up a database table, and I keep
getting an error saying:
Max key length is 500
I have looked everywhere I can think of but I can't find an explanation
for what is causing the problem so I can fix it, can anyone help me?
Thanks,
Brian Rivet
On 10 Jul 2003 at 16:19, Brian Rivet wrote:
Max key length is 500
I have looked everywhere I can think of but I can't find an
explanation for what is causing the problem so I can fix it, can
anyone help me?
Presumably your key length is too long, but since you don't give us
any clue about
Sorry, I'm a little new at this, here's the statement:
CREATE TABLE `TblUsers` (`UserId` INT(5) UNSIGNED DEFAULT NULL NOT NULL
AUTO_INCREMENT, `FirstName` VARCHAR(255) DEFAULT 'unknown' NOT NULL,
`LastName` VARCHAR(255) DEFAULT 'unknown' NOT NULL, `UserName`
VARCHAR(255) DEFAULT 'unknown' NOT
On 10 Jul 2003 at 16:33, Brian Rivet wrote:
CREATE TABLE `TblUsers` (`UserId` INT(5) UNSIGNED DEFAULT NULL NOT
NULL AUTO_INCREMENT, `FirstName` VARCHAR(255) DEFAULT 'unknown' NOT
NULL, `LastName` VARCHAR(255) DEFAULT 'unknown' NOT NULL, `UserName`
VARCHAR(255) DEFAULT 'unknown' NOT NULL,