Re: create sequence

[Michael Stassen]

I believe you want an AUTO_INCREMENT column.

  CREATE TABLE yourtable
    (customer_id AUTO_INCREMENT NOT NULL PRIMARY KEY, other_columns...);
See the manual <http://www.mysql.com/doc/en/CREATE_TABLE.html> and 
<http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html> for more.

Michael

jdavis wrote:

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,


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