I failed mention that I am using the ODBC driver to access this database.
Everything works great using the Unix client but not the ODBC driver. It
seems to have something to do with using DAO. I tried RDO and the
last_insert_id() is now working.
Can anybody confirm this?
Paul DuBois
<[EMAIL PROTECTED]> To: "Eric Baines"
<[EMAIL PROTECTED]>, [EMAIL PROTECTED]
cc:
03/25/02 03:02 PM Subject: Re: Auto_increment and
TimeStamp Fields
At 14:54 -0500 3/25/02, Eric Baines wrote:
>I have created a table with a Primary Key that is an auto_incrementing
>field. I was able to receive the auto_increment values by issuing a
>last_insert_id(). When I added a timestamp to this table, the
>last_insert_id() no longer returned any value except 0.
>
>Is there a MySQL rule that you can not have an auto_increment field and a
>timestamp field in the same table?
No, you can have both.
mysql> CREATE TABLE t
-> (i INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> ts TIMESTAMP);
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO t SET ts = NULL;
Query OK, 1 row affected (0.01 sec)
mysql> SELECT LAST_INSERT_ID();
+------------------+
| last_insert_id() |
+------------------+
| 1 |
+------------------+
1 row in set (0.01 sec)
mysql> INSERT INTO t SET ts = NULL;
Query OK, 1 row affected (0.00 sec)
mysql> SELECT LAST_INSERT_ID();
+------------------+
| last_insert_id() |
+------------------+
| 2 |
+------------------+
1 row in set (0.00 sec)
mysql> SELECT * FROM t;
+---+----------------+
| i | ts |
+---+----------------+
| 1 | 20020325140102 |
| 2 | 20020325140102 |
+---+----------------+
2 rows in set (0.00 sec)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
