Re: Max Key Length Error

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, `

Max Key Length Error

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 NUL

Re: Max key length error

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 a

Max key length error

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