Hi,
I'm new to MySQL coming from PostgreSQL backgroud. I'd like to know how to
obtain the same effect of a sequence + concat as default value of a table
in
mysql. For example, consider the following table definition:
CREATE TABLE competenza
(
id_competenza character varying(30) NOT NULL
I don't think MySQL has exactly what you are looking for, but you may be able
to get the behavior you want.
The auto_increment value is actually based on an index and doesn't have to be unique. So you could create a compound index that has
one or more fields plus the auto_increment field. The
On Tuesday 02 January 2007 16:51 Brent Baisley's cat, walking on the keyboard,
wrote:
CREATE TABLE competenza (
competenza varchar(30) NOT NULL default 'comp-06-',
id_competenza int unsigned not null auto_increment,
descrizione varchar(100),
PRIMARY KEY (competenza, id_competenza)
)
Hi,
CREATE TABLE competenza (
competenza varchar(30) NOT NULL default 'comp-06-',
id_competenza int unsigned not null auto_increment,
descrizione varchar(100),
PRIMARY KEY (competenza, id_competenza)
)
Since your PRIMARY KEY is a combination of 2 fields (competenza +
I had a similar problem a while ago and I got round it by using a trigger -
called a function on an insert to
read a value from a table (use for update when selecting)
update with incremented value
then use the return value from the ffunction to set the new value -
you can do all your login or
Hello Chad,
Does mysql have sequences?
No, it does not.
If not what is the functional equivalent?
auto-increment would be the closest.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
Hello,
I am new to mysql. I want to create sequences in mysql 4.0 which
should be equivalent to oracle sequences. I gone through the mysql
manual, Auto_Increment(), C API mysql_insert_id() and LAST_INSERT_ID()
are there for sequences. Last_insert_id() gives the last value.
I want actual
[snip]
I was wondering whether it was possible to make and AUTO_INCREMENT
field instead of always adding 1 and starting at zero, into a SEQUENCE
type field so that it is say a 10 digit integer and numbers are created
according to the SEQUENCE.
[/snip]
I was wondering if you had tried it in a
Hi,
As far as I know, definitely not. However, you could use an
AUTO_INCREMENT field as the independent variable
for some application-level function you use to generate the values in
the sequence.
Best regards,
Chris
Graham Little wrote:
I was wondering whether it was possible to make and
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:03
To: Graham Little; [EMAIL PROTECTED]
Subject: RE: SEQUENCES
[snip]
I was wondering whether it was possible to make and AUTO_INCREMENT
field instead of always adding 1 and starting at zero
Try
Insert INTO `table` ( `inc_field` ) values (10)
the auto inc field will then generate the next sequential numbers
HTH
Peter
-Original Message-
From: Graham Little [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:01
To: '[EMAIL PROTECTED]'
Subject: SEQUENCES
I was
Hi Chris,
Thanks for your help, i will find another way around it.
Graham
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:13
To: Graham Little
Cc: '[EMAIL PROTECTED]'
Subject: Re: SEQUENCES
Hi,
As far as I know, definitely not. However, you
On Mon, 15 Dec 2003, Peter Lovatt wrote:
Try
Insert INTO `table` ( `inc_field` ) values (10)
the auto inc field will then generate the next sequential numbers
HTH
Peter
Or just use
ALTER TABLE table AUTO_INCREMENT=10
That way you don't have to enter a record just to set
I prefer to use Auto_Increment for ease of use. In addition, I don't think
that MySQL supports sequences outright (like you may be used to with
Oracle). There are some workarounds availabe within the MySQL manual, do a
search with sequences.
Good Luck,
Dennis
14 matches
Mail list logo