RE: create sequence

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

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

: 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

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

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

[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

Re: create sequence

I believe you want an AUTO_INCREMENT column. CREATE TABLE yourtable (customer_id AUTO_INCREMENT NOT NULL PRIMARY KEY, other_columns...); See the manual and for more. Michael jdavis wr

RE: CREATE SEQUENCE

It's a command used for creating the equvalent of AUTO_INCREMENT columns in other dialects of SQL. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq > -Original Message- > From: Bryan Capitano [mailto:[EMAIL PROTECTED]] >

Re: CREATE SEQUENCE

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 do