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)