How to retrieve the Identity/auto_increment fireld after an insert in MYSQL

Hi,Can you be more precise? After inserting a records into the database the auto_increment field will be filled in automatically by mysql.When you run a SELECT * FROM <tablename> it will show up. If it shows up as 0 you forgot to refresh the dataprovider.

Thanks for the input. "SELECT LAST_INSERT_ID()" or "mysql_insert_id()" is what I'm looking for. I am using a Cached Rowset Data Provider and was hoping to avoid using DBMS-specific functionality. I thought that JSC might provide a method to get the insert_id but couldn't find it.