Can you find the syntax error?
Posted: Sun Dec 05, 2004 12:18 pm
I'm creating this mysql statement from another mysql table using php. Here is the mysql error message and the sql that was created. It's long, but the entry in question is at the very end.
Any help would be great!
Any help would be great!
Code: Select all
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'White_Red enum('Y','N') not null default "N"' at line 1
create table product_colors (id int not null primary key auto_increment,Royal enum('Y','N') not null default "N",Red_Black_Offwhite enum('Y','N') not null default "N",Red_Black enum('Y','N') not null default "N",Red enum('Y','N') not null default "N",Raspberry enum('Y','N') not null default "N",Purple enum('Y','N') not null default "N",Powder_Blue enum('Y','N') not null default "N",Poppy enum('Y','N') not null default "N",Pink enum('Y','N') not null default "N",Pebble enum('Y','N') not null default "N",Pale_Blue enum('Y','N') not null default "N",Orange_Black enum('Y','N') not null default "N",Orange enum('Y','N') not null default "N",Olive enum('Y','N') not null default "N",Navy_Yellow enum('Y','N') not null default "N",Navy_Red_Yellow enum('Y','N') not null default "N",Navy_Red_Jade enum('Y','N') not null default "N",Navy_Deep_Navy enum('Y','N') not null default "N",Navy enum('Y','N') not null default "N",Natural_ enum('Y','N') not null default "N",Mid_Blue enum('Y','N') not null default "N",Marine_Navy enum('Y','N') not null default "N",Lime enum('Y','N') not null default "N",Lilac enum('Y','N') not null default "N",Light_Red enum('Y','N') not null default "N",Light_Oxford enum('Y','N') not null default "N",Light_Blue enum('Y','N') not null default "N",Lemon enum('Y','N') not null default "N",Laser_Blue enum('Y','N') not null default "N",Khaki enum('Y','N') not null default "N",Jade enum('Y','N') not null default "N",Ice_Green enum('Y','N') not null default "N",Ice enum('Y','N') not null default "N",Heather_Navy_Claret enum('Y','N') not null default "N",Heather enum('Y','N') not null default "N",Grey enum('Y','N') not null default "N",Green_Black enum('Y','N') not null default "N",Graphite enum('Y','N') not null default "N",Gold enum('Y','N') not null default "N",French_Navy enum('Y','N') not null default "N",Forest_Green enum('Y','N') not null default "N",Emerald enum('Y','N') not null default "N",Dusty_Blue enum('Y','N') not null default "N",Deep_Navy enum('Y','N') not null default "N",Dark_Heather enum('Y','N') not null default "N",Cream enum('Y','N') not null default "N",Classic_Red enum('Y','N') not null default "N",Claret_Navy enum('Y','N') not null default "N",Claret enum('Y','N') not null default "N",Charcoal enum('Y','N') not null default "N",Camouflage_Green enum('Y','N') not null default "N",Burgundy enum('Y','N') not null default "N",Brown enum('Y','N') not null default "N",Bright_Royal enum('Y','N') not null default "N",Bright_Blue enum('Y','N') not null default "N",Brick_Red enum('Y','N') not null default "N",Bottle_Green enum('Y','N') not null default "N",Black_Red_Offwhite enum('Y','N') not null default "N",Black_Putty_Silver enum('Y','N') not null default "N",Black enum('Y','N') not null default "N",Birch enum('Y','N') not null default "N",Big_Blue enum('Y','N') not null default "N",Begonia enum('Y','N') not null default "N",Baby_Green enum('Y','N') not null default "N",Azure enum('Y','N') not null default "N",Ash enum('Y','N') not null default "N",Aqua enum('Y','N') not null default "N",Air_Force_Blue enum('Y','N') not null default "N",Royal_Black enum('Y','N') not null default "N",Sand enum('Y','N') not null default "N",Silver_Grey enum('Y','N') not null default "N",Sky enum('Y','N') not null default "N",Slate_Grey enum('Y','N') not null default "N",Stone enum('Y','N') not null default "N",Sunflower enum('Y','N') not null default "N",White enum('Y','N') not null default "N",White_Black enum('Y','N') not null default "N",White_BlueMelange_Navy enum('Y','N') not null default "N",White_BrightRed enum('Y','N') not null default "N",White_Navy enum('Y','N') not null default "N",White_Ocean enum('Y','N') not null default "N",White_Red_Black enum('Y','N') not null default "N",White_Red_Navy enum('Y','N') not null default "N",Winter_Emerald enum('Y','N') not null default "N",Yellow enum('Y','N') not null default "N",Yellow_Black enum('Y','N') not null default "N",Zinc enum('Y','N') not null default "N",Powder_Pink enum('Y','N') not null default "N",Bright_Red enum('Y','N') not null default "N",Steel_Grey enum('Y','N') not null default "N",Black_Charcoal enum('Y','N') not null default "N",BrightRoyal_FrenchNavy enum('Y','N') not null default "N",ClassicRed_FrenchNavy enum('Y','N') not null default "N",FrenchNavy_BottleGreen enum('Y','N') not null default "N",FrenchNavy_FrenchNavy enum('Y','N') not null default "N",Khaki_FrenchNavy enum('Y','N') not null default "N",Black_Grey enum('Y','N') not null default "N",Grey_Navy enum('Y','N') not null default "N",Navy_Grey enum('Y','N') not null default "N",Royal_Grey enum('Y','N') not null default "N",Royal_Grey enum('Y','N') not null default "N",Yellow_Navy enum('Y','N') not null default "N",Black_Black enum('Y','N') not null default "N",BottleGreen_Black enum('Y','N') not null default "N",Navy_Black enum('Y','N') not null default "N",Grey_FrenchNavy enum('Y','N') not null default "N",BottleGreen_BottleGreen enum('Y','N') not null default "N",Burgundy_Camel enum('Y','N') not null default "N",Navy_Navy enum('Y','N') not null default "N",Red_Navy enum('Y','N') not null default "N",Royal_Navy enum('Y','N') not null default "N",Aubergine enum('Y','N') not null default "N",Mustard enum('Y','N') not null default "N",Ecru enum('Y','N') not null default "N",Kelly enum('Y','N') not null default "N",Bordeaux_Putty enum('Y','N') not null default "N",Navy_Putty enum('Y','N') not null default "N",Putty_Navy enum('Y','N') not null default "N",Black_White enum('Y','N') not null default "N",Black_White enum('Y','N') not null default "N",ClassicRed_White enum('Y','N') not null default "N",FrenchNavy_White enum('Y','N') not null default "N",Navy_White enum('Y','N') not null default "N",Sky_Navy enum('Y','N') not null default "N",Black_Red enum('Y','N') not null default "N",Navy_Red enum('Y','N') not null default "N",Navy_Taupe enum('Y','N') not null default "N",Grey_Black enum('Y','N') not null default "N",White_Royal enum('Y','N') not null default "N",White_Kelly enum('Y','N') not null default "N",White_Red enum('Y','N') not null default "N",junk int)