Value of auto_increment

[Anon]

I'm a little confused.

When I insert a record an ID field is set automaticly with auto_increment.

Is there a way to find out which number was inserted in the ID field without running another query.

Thanx

[kparker]

What database are you using? This is entirely db-specific (nothing in standard SQL about auto-increment anything), but if it's mysql, you can call mysql_insert_id().

[Anon]

i friend , are using a sequence for auto increament, if using this
and is this done at sql plus or using application

iam answering it for sqlplus

after insert a record into the table

give statement at sql

select <sequence name.curvalue> from <tablename >

this query will give you the current or last sequence value for record