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_title varchar(50), > quans_to_quote varchar(10), > other_quan varchar(50), > size_flat varchar(15), > size_folded varchar(15), > other_flat varchar(50), > other_folded varchar(50), > pages varchar(50), > other_pages varchar(50), > text_weight varchar(50), > cover_weight varchar(50), > apso varchar(255), > ink_specs varchar(50), > other_ink varchar(50), > varn_or_uv varchar(50), > bindery varchar(50), > other_bindery varchar(255), > ajs varchar(255), > shipto varchar(255), > ship_via varchar(50), > asi varchar(255), > company_name varchar(100), > contact varchar(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]
