On Sun, Dec 27, 2009 at 11:27 AM, Mattia Merzi <mattia.me...@gmail.com>wrote:
> 2009/12/27 Victor Subervi <victorsube...@gmail.com>: > > mysql> select * from products; > [...] > > mysql> select last_insert_id() from products; > [...] > > Now, I was expecting 1, not 0! What up? > > [...] LAST_INSERT_ID() (no arguments) returns the first > automatically generated value successfully inserted for > an AUTO_INCREMENT column as a result of the most > recently executed INSERT statement. [...] If no rows > were (successfully) inserted, LAST_INSERT_ID() returns 0. > But it *is* auto incremented! mysql> describe products; +--------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+------------+----------------+ | ID | tinyint(5) unsigned | NO | PRI | NULL | auto_increment | | SKU | varchar(40) | NO | UNI | NULL | | | Category | varchar(40) | YES | | NULL | | | Name | varchar(50) | NO | | NULL | | | Title | varchar(100) | NO | | NULL | | | Description | mediumtext | NO | | NULL | | | Price | float(8,2) | YES | | NULL | | | SortFactor | int(4) | YES | | 500 | | | Availability | tinyint(1) | NO | | 1 | | | OutOfStock | tinyint(1) | NO | | 0 | | | ShipFlatFee | float(5,2) | NO | | 10.00 | | | ShipPercentPrice | tinyint(2) unsigned | NO | | 5 | | | ShipPercentWeight | tinyint(2) unsigned | NO | | 2 | | | Associations | varchar(40) | NO | | NULL | | | TempPrice | tinyint(1) | NO | | 1 | | | LastDatePrice | date | NO | | 2000-01-01 | | | Weight | float(7,2) | NO | | NULL | | | Metal | enum('14k gold','18k gold','white gold','silver','tungsten','titanium') | NO | | NULL | | | PercentMetal | tinyint(2) unsigned | NO | | NULL | | | pic0 | mediumblob | YES | | NULL | | | pic1 | mediumblob | YES | | NULL | | | sizes | set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge') | YES | | NULL | | | colorsShadesNumbersShort | set('blue:333399','gray:465945','purple:50404D','navy-blue:CC7722','fuchsia:FF77FF','aqua:7FFFD4','maroon:B03060','black:0000FF','yellow:9ACD32') | YES | | NULL | | +--------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+------------+----------------+ 23 rows in set (0.00 sec) mysql>