DROP TABLE IF EXISTS lenses; CREATE TABLE lenses ( id int(10) unsigned NOT NULL AUTO_INCREMENT, mount enum( 'EF', 'EF-S', 'TS-E', 'MP-E' ), wide int, tele int, ap_wide int, ap_tele int, focus enum( 'USM', 'FT-M' ), istab enum( 'Y', 'N' ), macro enum( 'Y', 'N' ), filter int, series enum( 'C', 'DO', 'S', 'G', 'L' ), bhcn char(24), price int, PRIMARY KEY (id) ) TYPE=MyISAM; insert into lenses values( NULL, 'EF-S', 10, 22, 350, 450, 'FT-M', 'N', 'N', 77, 'G', 'CA102235EF ', 710 ); insert into lenses values( NULL, 'EF', 16, 35, 280, 280, 'FT-M', 'N', 'N', 82, 'L', 'CA163528LEF2 ', 1450 ); insert into lenses values( NULL, 'EF', 17, 40, 400, 400, 'FT-M', 'N', 'N', 77, 'L', 'CA17404LEF ', 700 ); insert into lenses values( NULL, 'EF-S', 17, 55, 280, 280, 'FT-M', 'Y', 'N', 77, 'G', 'CA175528IS ', 1030 ); insert into lenses values( NULL, 'EF-S', 17, 85, 400, 560, 'FT-M', 'Y', 'N', 67, 'G', 'CA17854ISWB ', 450 ); insert into lenses values( NULL, 'EF-S', 18, 55, 350, 560, 'USM', 'Y', 'N', 58, 'S', 'CA1855EFS ', 170 ); insert into lenses values( NULL, 'EF', 24, 70, 280, 280, 'FT-M', 'N', 'N', 77, 'L', ' ', 1150 ); insert into lenses values( NULL, 'EF', 24, 85, 350, 450, 'FT-M', 'N', 'N', 67, 'G', ' ', 310 ); insert into lenses values( NULL, 'EF', 28, 105, 350, 450, 'FT-M', 'N', 'N', 58, 'G', ' ', 230 ); insert into lenses values( NULL, 'EF', 28, 105, 400, 560, 'USM', 'N', 'N', 58, 'S', ' ', 140 ); insert into lenses values( NULL, 'EF', 24, 105, 400, 400, 'FT-M', 'Y', 'N', 77, 'L', ' ', 1150 ); insert into lenses values( NULL, 'EF', 28, 135, 350, 560, 'FT-M', 'Y', 'N', 72, 'G', ' ', 420 ); insert into lenses values( NULL, 'EF', 28, 200, 350, 560, 'USM', 'N', 'N', 72, 'S', ' ', 360 ); insert into lenses values( NULL, 'EF', 28, 300, 350, 560, 'FT-M', 'Y', 'N', 77, 'L', ' ', 2200 ); insert into lenses values( NULL, 'EF', 28, 90, 400, 560, 'USM', 'N', 'N', 58, 'S', ' ', 110 ); ' insert into lenses values( NULL, 'EF', 55, 200, 450, 560, 'USM', 'N', 'N', 52, 'S', ' ', 210 ); insert into lenses values( NULL, 'EF', 70, 200, 280, 280, 'FT-M', 'Y', 'N', 77, 'L', ' ', 1700 ); insert into lenses values( NULL, 'EF', 70, 200, 280, 280, 'FT-M', 'N', 'N', 77, 'L', ' ', 1140 ); insert into lenses values( NULL, 'EF', 70, 200, 400, 400, 'FT-M', 'Y', 'N', 67, 'L', ' ', 1250 ); insert into lenses values( NULL, 'EF', 70, 200, 400, 400, 'FT-M', 'N', 'N', 67, 'L', ' ', 585 ); insert into lenses values( NULL, 'EF', 70, 300, 400, 560, 'USM', 'Y', 'N', 58, 'G', ' ', 560 ); insert into lenses values( NULL, 'EF', 70, 300, 400, 560, 'FT-M', 'Y', 'N', 58, 'DO', ' ', 1150 ); insert into lenses values( NULL, 'EF', 75, 300, 400, 560, 'USM', 'N', 'N', 58, 'S', ' ', 190 ); insert into lenses values( NULL, 'EF', 75, 300, 400, 560, NULL, 'N', 'N', 58, 'S', ' ', 160 ); insert into lenses values( NULL, 'EF', 100, 300, 450, 560, 'FT-M', 'N', 'N', 58, 'G', ' ', 280 ); insert into lenses values( NULL, 'EF', 100, 400, 450, 560, 'FT-M', 'Y', 'N', 77, 'L', ' ', 1400 ); insert into lenses values( NULL, 'EF', 14, 14, 280, 280, 'FT-M', 'N', 'N', 77, 'L', ' ', 1800 ); insert into lenses values( NULL, 'EF', 15, 15, 280, 280, NULL, 'N', 'N', 77, 'C', ' ', 580 ); insert into lenses values( NULL, 'EF', 20, 20, 280, 280, 'FT-M', 'N', 'N', 72, 'G', ' ', 420 ); insert into lenses values( NULL, 'EF', 24, 24, 140, 140, 'FT-M', 'N', 'N', 77, 'L', ' ', 1120 ); insert into lenses values( NULL, 'EF', 24, 24, 280, 280, NULL, 'N', 'N', 58, 'C', ' ', 290 ); insert into lenses values( NULL, 'EF', 28, 28, 280, 280, NULL, 'N', 'N', 52, 'C', ' ', 170 ); insert into lenses values( NULL, 'EF', 35, 35, 140, 140, 'FT-M', 'N', 'N', 72, 'L', ' ', 1135 ); insert into lenses values( NULL, 'EF', 35, 35, 200, 200, NULL, 'N', 'N', 52, 'C', ' ', 230 ); insert into lenses values( NULL, 'EF', 28, 28, 180, 180, 'FT-M', 'N', 'N', 58, 'G', ' ', 400 ); insert into lenses values( NULL, 'EF', 50, 50, 120, 120, 'FT-M', 'N', 'N', 72, 'L', ' ', 1600 ); insert into lenses values( NULL, 'EF', 50, 50, 140, 140, 'FT-M', 'N', 'N', 58, 'G', ' ', 315 ); insert into lenses values( NULL, 'EF', 50, 50, 180, 180, NULL, 'N', 'N', 52, 'C', ' ', 80 ); insert into lenses values( NULL, 'EF', 85, 85, 120, 120, 'FT-M', 'N', 'N', 72, 'L', ' ', 2050 ); insert into lenses values( NULL, 'EF', 85, 85, 180, 180, 'FT-M', 'N', 'N', 58, 'G', ' ', 340 ); insert into lenses values( NULL, 'EF', 100, 100, 200, 200, 'FT-M', 'N', 'N', 58, 'G', ' ', 390 ); insert into lenses values( NULL, 'EF', 135, 135, 200, 200, 'FT-M', 'N', 'N', 72, 'L', ' ', 900 ); insert into lenses values( NULL, 'EF', 135, 135, 280, 280, NULL, 'N', 'N', 52, 'C', ' ', 280 ); insert into lenses values( NULL, 'EF', 200, 200, 280, 280, 'FT-M', 'N', 'N', 72, 'L', ' ', 660 ); insert into lenses values( NULL, 'EF', 300, 300, 400, 400, 'FT-M', 'Y', 'N', 77, 'L', ' ', 1150 ); insert into lenses values( NULL, 'EF', 300, 300, 280, 280, 'FT-M', 'Y', 'N', 52, 'L', ' ', 3900 ); insert into lenses values( NULL, 'EF', 400, 400, 560, 560, 'FT-M', 'N', 'N', 77, 'L', ' ', 1100 ); insert into lenses values( NULL, 'EF', 400, 400, 400, 400, 'USM', 'Y', 'N', 52, 'DO', ' ', 5300 ); insert into lenses values( NULL, 'EF', 400, 400, 280, 280, 'FT-M', 'Y', 'N', 52, 'L', ' ', 6600 ); insert into lenses values( NULL, 'EF', 500, 500, 400, 400, 'FT-M', 'Y', 'N', 52, 'L', ' ', 5500 ); insert into lenses values( NULL, 'EF', 600, 600, 400, 400, 'FT-M', 'Y', 'N', 52, 'L', ' ', 7200 ); insert into lenses values( NULL, 'EF', 50, 50, 250, 250, NULL, 'N', 'Y', 52, 'C', ' ', 240 ); insert into lenses values( NULL, 'EF-S', 60, 60, 280, 280, 'FT-M', 'N', 'Y', 52, 'G', ' ', 385 ); insert into lenses values( NULL, 'MP-E', 65, 65, 280, 280, NULL, 'N', 'Y', 58, 'C', ' ', 830 ); insert into lenses values( NULL, 'EF', 100, 100, 280, 280, 'FT-M', 'N', 'Y', 58, 'G', ' ', 450 ); insert into lenses values( NULL, 'EF', 180, 180, 350, 350, 'FT-M', 'N', 'Y', 72, 'L', ' ', 1240 ); insert into lenses values( NULL, 'TS-E', 24, 24, 350, 350, NULL, 'N', 'N', 72, 'L', ' ', 1100 ); insert into lenses values( NULL, 'TS-E', 45, 45, 280, 280, NULL, 'N', 'N', 72, 'C', ' ', 1100 ); insert into lenses values( NULL, 'TS-E', 90, 90, 280, 280, NULL, 'N', 'N', 58, 'C', ' ', 1100 );