sql file works with mysql 4.0.16 but not 3.23

[jdavis]

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.
 
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]

create sequence

[jdavis]

hello,
 I have mysql version 4.0.16. I am trying to create a sequence to use
for a customer_id field. Anyway I try this ...

CREATE SEQUENCE new_num start 1 increment 1 maxvalue
9223372036854775807 minvalue 1 cache 1;

or just

CREATE SEQUENCE new_num;

and both give me a sytax error. What am I doing wrong?

Thanks,
-- 
jdavis [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]