еще немного исследований
...
mysql> insert into tt1 values (3, 'ttt3');
Query OK, 1 row affected (0.03 sec)
mysql> select last_insert_id();
+------------------+
| last_insert_id() |
+------------------+
| 0 |
+------------------+
1 row in set (0.00 sec)
mysql> create unique index i1 on tt1 (col1);
Query OK, 3 rows affected (0.25 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> insert into tt1 values (4, 'ttt4');
Query OK, 1 row affected (0.02 sec)
mysql> select last_insert_id();
+------------------+
| last_insert_id() |
+------------------+
| 0 |
+------------------+
1 row in set (0.00 sec)
mysql> show create table tt1;
+-------+-----------------------------------------------------------------------
-----------------------------------------------------------------------------+
| Table | Create Table
|
+-------+-----------------------------------------------------------------------
-----------------------------------------------------------------------------+
| tt1 | CREATE TABLE `tt1` (
`col1` int(11) NOT NULL,
`col2` varchar(20) DEFAULT NULL,
UNIQUE KEY `i1` (`col1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+-----------------------------------------------------------------------
-----------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
так шо это не для ласт_инсерт_ид().
-~{}~ 08.12.09 15:23:
ну шо, пора вызывать тяжелую артилерию...
Апельсина или Света Смирнова, обьясните плизь, шо значит "
application asks for the PRIMARY KEY"?