LAST_INSERT_ID()

[Todd Holtzinger]

Thank you in advance!

I am trying to use the LAST_INSERT_ID() function but, always get 0 (zero) as the returned value.
Here are the details as I see it.

Server: Novell Netware 6.0
MySQL: 4.1.10
MySQL Query Browser: 1.1.5

Table name: Animals myisam
Field: ID - mediumint(9) not null auto inc
Name - char(30) not null
Index: ID - Primary btree


COMMANDS:

INSERT INTO animals (ID, name) VALUES (NULL,'rabbit') ;

SELECT Last_Insert_ID() ;

I assume that MySQL Query Browser would only use one connection and when MySQL Administrator is checked there are only two threads and the PID is not changing. What am I missing?


Todd