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. thanks, -- [EMAIL PROTECTED] "Bad spellers of the world untie!" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]