I know how to create tables in mysql, but for some reason when I try to create the following table:
create table `-1` (
id int not null,
file_name varchar(40) not null,
name varchar(40),
photograhper varchar(40) not null,
format varchar(40),
pixel_size varchar(40),
color_depth varchar(40),
file_size varchar(40),
shooting_date_month int not null,
shooting_date_day int not null,
shooting_date_year int not null,
shooting_date_hour int not null,
shooting_date_minute int not null,
shooting_date_sec int not null,
updated_date_month int,
updated_date_day int,
updated_date_year int,
updated_date_hour int,
updated_date_minute int,
updated_date_sec int,
comments varchar(100),
mode varchar(40),
aperture varchar(40),
shutter_speed varchar(40),
exposure_compensation varchar(40),
ISO varchar(40),
focal_length varchar(40),
flash varchar(40),
macro varchar(40),
image_title varchar(40)
image_input_equipment_manufacturer varchar(40),
image_input_equipment_model varchar(40),
orientation varchar(40),
exif_version varchar(40),
exposure_bias varchar(40),
maximum_lens_aperture varchar(40),
metering_mode varchar(40),
light_source varchar(40),
lens_focal_length varchar(40),
supported_flashpix_version varchar(40),
white_balance varchar(40),
digital_zoom_ratio varchar(40),
scene_capture_type varchar(40),
gain_control varchar(40),
contrast varchar(40),
saturation varchar(40),
sharpness varchar(40));
I get the following error:
ERROR 1064 (42000): 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 'image_input_equipment_manufacturer varchar(40), image_input_exuipment_model varc' at line 32
Any ideas on how to resolve this error?
Thanks,
Campsoup1988
