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,
[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
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
:
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
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
]]
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
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
12 matches
Mail list logo