>
> Mike Hillyer
>
> -Original Message-
> From: Chuck Tomasi [mailto:Chuck.Tomasi@;plexus.com]
> Sent: Monday, October 21, 2002 7:19 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Using AUTO_INCREMENT like SEQUENCE - Resolved
>
>
> This past weekend the solution came t
At 16:57 +0200 10/21/02, Joseph Bueno wrote:
Hi all,
Sorry to jump in the middle of this thread but there is a much simpler
way to generate sequence numbers:
You create an auxiliary table with a one row:
CREATE TABLE sequence (
code int(11) DEFAULT '0' NOT NULL
);
INSERT INTO sequence VALUES (
Chuck,
last_insert_id() is per-connection. How do you see two users getting the
same auto_increment value?
PB
-
- Original Message -
From: "Chuck Tomasi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 18, 2002 9:07 AM
Subject: Using AUTO_I
General Info:
OS: Mac OS X
MySQL version: 3.23.52 (Jaguar)
PERL: 5.6.0
DBI: 1.30
I've got an application that was written to use Oracle sequences, as such
the program pulls a sequence number then creates a file based on that
number and populates a database record with infomation. I've read
ever
