Max Key Length Error

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Brian Rivet

    Max Key Length Error

    ------=_NextPart_000_ 000E_01C34700.F E251100
    Content-Type: text/plain;
    charset="us-ascii"
    Content-Transfer-Encoding: 7bit

    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 NULL, `UserPass` VARCHAR(255) DEFAULT
    'unknown' NOT NULL , PRIMARY KEY (`UserId`), INDEX (`UserId`,
    `LastName`, `UserName`), UNIQUE (`UserId`, `UserName`))

    It says the max key length is 500, I'm not sure what it's referring to,
    so I don't know what to fix.

    Thanks for any help you can give me.

    Brian Rivet

    ------=_NextPart_000_ 000E_01C34700.F E251100--


Working...