Re: ENUM Restriction? Number of columns doesn't matter.

[Joseph Caristi]

Exact error is "ERROR Code : 1117 Too many columns"

I cannot include the entire script because it is too large. An abbreviated script is here (the only thing missing is extra ENUM entries - actual number is about 6450):

CREATE TABLE `Application4` (
`Application4Id` INT unsigned NOT NULL AUTO_INCREMENT,
`PartTerminologyName`

ENUM (

'3 Way Terminal',
'4 Way Terminal',
'4WD Actuator',
'4WD Actuator Wire Harness',
'4WD Disconnect',
'4WD Switch',
'A.I.R Control Relay',
'A/C Accumulator',

...

'Workbench',
'Worklight',
'Wristwatch',
'X-Contact Relay',
'Xenon Headlight Bulb',
'Xenon Headlight Control Module',
'Xenon Headlight Control Relay',
'Xenon Headlight Igniter'),
PRIMARY KEY(Application4Id)
) ENGINE=innodb;