Code Forums - View Single Post

falsepride · 02-14-2008, 07:37 PM

Code:

  CREATE TABLE `managers` (
`name` TEXT NOT NULL ,
`password` TEXT NOT NULL ,
`webmaster` BOOL NOT NULL ,
PRIMARY KEY ( `name` )
) TYPE = MYISAM

#1170 - BLOB/TEXT column 'name' used in key specification without a key length

02-14-2008, 07:37 PM	#9 (permalink)
falsepride Regular Contributor Join Date: Oct 2004 Posts: 207	Code: CREATE TABLE `managers` ( `name` TEXT NOT NULL , `password` TEXT NOT NULL , `webmaster` BOOL NOT NULL , PRIMARY KEY ( `name` ) ) TYPE = MYISAM #1170 - BLOB/TEXT column 'name' used in key specification without a key length