RE: create sequence

2005-01-13 Thread Frank Bax
sing something here, or does someone know how to handle 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 AU

RE: create sequence

2005-01-13 Thread SGreen
process inside a transaction so that you serialize access to the data on your sequencing table. Shawn Green Database Administrator Unimin Corporation - Spruce Pine > -Original Message- > From: Peter Brawley [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 13, 2005 11:38 AM > To

RE: create sequence

2005-01-13 Thread Scott Purcell
: 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

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: h

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 how

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? http://d

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

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

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

RE: CREATE SEQUENCE

2001-07-27 Thread Carsten H. Pedersen
L PROTECTED]] > 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 sec

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> Bry

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