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]

Reply via email to