5 messages in com.mysql.lists.javareading the AUTO_INCREMENT value...
FromSent OnAttachments
Bjorn Ehinger03 Feb 2000 00:23 
Don Gourley03 Feb 2000 09:44 
Glenn Crownover03 Feb 2000 17:29 
Mark Matthews04 Feb 2000 05:29 
Mark Matthews04 Feb 2000 05:44 
Subject:reading the AUTO_INCREMENT value...
From:Bjorn Ehinger (bjo@it.kth.se)
Date:02/03/2000 12:23:52 AM
List:com.mysql.lists.java

Hi!

If I have a table in MySQL, defined someting like this (dummy example):

CREATE TABLE objects ( object_ID BIGINT NOT NULL AUTO_INCREMENT, object_name VARCHAR(20) NOT NULL );

When executing the command:

INSERT INTO objects (object_name) VALUES ('hello');

Using JDBC, is there any way I can receive the object_ID generated by the AUTO_INCREMENT?

Thanks. BjornE