Try sequences.
Dave
On Thu, Dec 13, 2001 at 06:18:32PM -, Matthew Smith wrote:
> the SELECT LAST_INSERT_ID() gets the last autoincremented number for the
> current connection.
>
> See http://www.mysql.com/doc/G/e/Getting_unique_ID.html
>
> The auto_incremenet field is sadly lacking in Orac
the SELECT LAST_INSERT_ID() gets the last autoincremented number for the
current connection.
See http://www.mysql.com/doc/G/e/Getting_unique_ID.html
The auto_incremenet field is sadly lacking in Oracle (IMHO).
M
-Original Message-
From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]]
Sen
You can lock the table when you insert.
mike
-Original Message-
From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 9:25 AM
To: [EMAIL PROTECTED]
Subject: SV: sequence and nextval
Thanks, but how secure is this. Is it possible for two computers to do
th
> Thanks, but how secure is this. Is it possible for two computers to do
> the "select" at the same time, i.e. get the new incremented value?
> Computer one insert, computer two insert, computer one select, computer
> two select?
>
> If this is possible how can I solve this? To make the column th
It depends what you need to do. For unique keys, I usually use
AUTO_INCREMENT feature.
mike
-Original Message-
From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 7:41 AM
To: [EMAIL PROTECTED]
Subject: sequence and nextval
Does the above functions exis
