[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?
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
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:
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
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
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
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
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
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]]