jdavis [EMAIL PROTECTED] wrote:
Hello,
i have a sql file that i use to build a table. It works on my Debian
testing box with mysql 4.0.16 but not on my woody box using mysql 3.23.
The error when i try to use the source command with my sql file
and version 3.23 of mysql is...
ERROR 1064: You have an error in your SQL syntax near ')' at line 34
here is the .sql file
CREATE TABLE new_quotes
(
quote_number int(10) PRIMARY KEY AUTO_INCREMENT,
dealer_number int(10),
the_date varchar(50),
ip varchar(50),
cust_serv_rep varchar(20),
quote_titlevarchar(50),
quans_to_quote varchar(10),
other_quan varchar(50),
size_flat varchar(15),
size_foldedvarchar(15),
other_flat varchar(50),
other_folded varchar(50),
pages varchar(50),
other_pagesvarchar(50),
text_weightvarchar(50),
cover_weight varchar(50),
apso varchar(255),
ink_specs varchar(50),
other_ink varchar(50),
varn_or_uv varchar(50),
binderyvarchar(50),
other_bindery varchar(255),
ajsvarchar(255),
shipto varchar(255),
ship_via varchar(50),
asivarchar(255),
company_name varchar(100),
contactvarchar(100),
contact_phone varchar(50),
contact_email varchar(100),
quote_needed varchar(100),
);
can someone tell me what im doing wrong.
Remove last comma from CREATE TABLE definition.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
