List:General Discussion« Previous MessageNext Message »
From:jdavis Date:March 17 2004 1:46am
Subject:create sequence
View as plain text  
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 <jd@stripped>

Thread
create sequencejdavis17 Mar
  • OS X 10.3.3 and byte ordering updateScott Haneda17 Mar
  • Re: create sequenceMichael Stassen17 Mar
Re: OS X 10.3.3 and byte ordering updateDavid Bourne17 Mar
  • Re: OS X 10.3.3 and byte ordering updatePaul DuBois17 Mar
    • Re: OS X 10.3.3 and byte ordering updateBrent Baisley17 Mar
    • Re: OS X 10.3.3 and byte ordering updatePaul Fierro17 Mar
RE: OS X 10.3.3 and byte ordering updateBob Bessares17 Mar