original message follows --
Date: Thu, 22 Jul 2004 22:56:12 -0700
Subject: Last insert id problem/bug
From: Scott Haneda <[EMAIL PROTECTED]>
I am not sure this is just how it is, my issue, or a bug, I searched the
bugs database, but don't really know what to call this in order
on 7/23/04 5:30 AM, Harald Fuchs at [EMAIL PROTECTED] wrote:
> The behavior is indeed strange, but it's not a bug, since it's documented:
>
> If you use `INSERT IGNORE' and the record is ignored, the
> `AUTO_INCREMENT' counter still is incremented and
> `LAST_INSERT_ID()' returns t
In article <[EMAIL PROTECTED]>,
Scott Haneda <[EMAIL PROTECTED]> writes:
> I am not sure this is just how it is, my issue, or a bug, I searched the
> bugs database, but don't really know what to call this in order to properly
> look up the info:
> MySQL 4.0.18-standard
> CREATE TABLE `addresses`
on 7/22/04 10:56 PM, Scott Haneda at [EMAIL PROTECTED] wrote:
> I am not sure this is just how it is, my issue, or a bug, I searched the
> bugs database, but don't really know what to call this in order to properly
> look up the info:
>
> MySQL 4.0.18-standard
Also note, I just tested this on 4.
I am not sure this is just how it is, my issue, or a bug, I searched the
bugs database, but don't really know what to call this in order to properly
look up the info:
MySQL 4.0.18-standard
CREATE TABLE `addresses` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
