Hi Michael
01.02.02 16:27:24, "Fochtman, Michael" <[EMAIL PROTECTED]> wrote:
>BMJI,
>
>But isn't 'last_insert_id()' only meant to be called after inserting a
>record?? If you've never inserted a record (using the current connection),
>it seems like calling 'last_insert_id()' would be a meaningl
Hi Bruce
01.02.02 15:41:49, Bruce Stewart <[EMAIL PROTECTED]> wrote:
>Hi Andreas,
>
>> >I think AUTO_INCREMENT is on a per-connection basis. So if
>> you're doing
>> >this across different database connections, it will reset to 0.
>[snip]
>> do a 'select * from where test=1' and you will
>>
e Fochtman
> -Original Message-
> From: Bruce Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 9:42 AM
> To: 'Andreas Schoelver'; [EMAIL PROTECTED]
> Subject: RE: AUTO_INCREMENT columns randomly restart counting from 1
>
>
> Hi Andre
Hi Andreas,
> >I think AUTO_INCREMENT is on a per-connection basis. So if
> you're doing
> >this across different database connections, it will reset to 0.
[snip]
> do a 'select * from where test=1' and you will
> see that the 2 new
> values will be visible to both of the clients.
As I unde
30.01.02 17:48:06, Richard Bolen <[EMAIL PROTECTED]> wrote:
>
>I think AUTO_INCREMENT is on a per-connection basis. So if you're doing
>this across different database connections, it will reset to 0.
no, that's not the case.
just try it.
crate a table with column id as auto_increment int and a
I think AUTO_INCREMENT is on a per-connection basis. So if you're doing
this across different database connections, it will reset to 0.
Rich
Hi there
We have some table used as sequences.
They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one
of them (ID).
By default
At 17:15 +0100 1/30/02, Andreas Schoelver wrote:
>Hi there
>
>We have some table used as sequences.
>They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set
>for one of them (ID).
Is the ID column one of the integer types?
>By default the tables are empty!
>The increment process is
Hi there
We have some table used as sequences.
They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one of them
(ID).
By default the tables are empty!
The increment process is done by inserting a new record with a random
value for the non-auto_increment column.
After that th
