create sequence

2005-01-13 Thread Scott Purcell
Hello, I would like to create a sequence object in mysql that I could use in multiple tables through a application I am developing. Could someone please send my the syntax of how to create a simple sequence that starts at 1 increments by 1. thanks,

RE: create sequence

2005-01-13 Thread Jay Blanchard
[snip] I would like to create a sequence object in mysql that I could use in multiple tables through a application I am developing. Could someone please send my the syntax of how to create a simple sequence that starts at 1 increments by 1. [/snip] Are you talking about auto-increment?

Re: create sequence

2005-01-13 Thread Peter Brawley
You want AUTO_INCREMENT, http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html. PB - Scott Purcell wrote: Hello, I would like to create a sequence object in mysql that I could use in multiple tables through a application I am developing. Could someone please send my the syntax of

Re: create sequence

2005-01-13 Thread Jochem van Dieten
On Thu, 13 Jan 2005 11:21:31 -0600, Scott Purcell wrote: I would like to create a sequence object in mysql that I could use in multiple tables through a application I am developing. Sequences are currently not supported in MySQL. Jochem -- MySQL General Mailing List For list archives:

RE: create sequence

2005-01-13 Thread Scott Purcell
To: Scott Purcell Cc: mysql@lists.mysql.com Subject: Re: create sequence You want AUTO_INCREMENT, http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html. PB - Scott Purcell wrote: Hello, I would like to create a sequence object in mysql that I could use in multiple tables through

RE: create sequence

2005-01-13 Thread SGreen
Database Administrator Unimin Corporation - Spruce Pine -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 11:38 AM To: Scott Purcell Cc: mysql@lists.mysql.com Subject: Re: create sequence You want AUTO_INCREMENT, http

RE: create sequence

2005-01-13 Thread Frank Bax
this in multiple tables? Scott -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 11:38 AM To: Scott Purcell Cc: mysql@lists.mysql.com Subject: Re: create sequence You want AUTO_INCREMENT, http://dev.mysql.com/doc/mysql/en/example

create sequence

2004-03-16 Thread 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

Re: create sequence

2004-03-16 Thread Michael Stassen
: 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

Re: CREATE SEQUENCE

2001-07-27 Thread Grigory Bakunov
Date |Thu, 26 Jul 2001 10:12:03 -0700 (PDT) From |Bryan Capitano [EMAIL PROTECTED] Hello! BC Hello, BC Does anybody know what the SQL statement: CREATE SEQUENCE do? BC I cannot find any info on this in the http://www.mysql.com/docs section. BC Thanks, BC Bryan Capitano AFAIK MySQL doesn't

RE: CREATE SEQUENCE

2001-07-27 Thread Carsten H. Pedersen
]] Sent: Thursday, July 26, 2001 7:12 PM To: MySQL Mailing List Subject: CREATE SEQUENCE Hello, Does anybody know what the SQL statement: CREATE SEQUENCE do? I cannot find any info on this in the http://www.mysql.com/docs section. Thanks, Bryan Capitano

CREATE SEQUENCE

2001-07-26 Thread Bryan Capitano
Hello, Does anybody know what the SQL statement: CREATE SEQUENCE do? I cannot find any info on this in the http://www.mysql.com/docs section. Thanks, Bryan Capitano - Before posting, please check: http://www.mysql.com