Know the autoincremental ID before insert

ben · Post by **ben** » Wed 02 Mar 2005 00:51

Hello, is it possible to know the auto incremental ID before doing the insert? Just to display in the user interface what is the next ID.

Thanks

Ikar · Post by **Ikar** » Wed 02 Mar 2005 09:03

Not, MySQL doesn't provide such functionality.

ben · Post by **ben** » Wed 02 Mar 2005 23:39

Well, it supports:

show table status like 'tablename' and read the "Auto_increment" field.

Ikar · Post by **Ikar** » Thu 03 Mar 2005 12:34

In the interval between this query and Post execution it might be an insertion of records from another client

ben · Post by **ben** » Thu 03 Mar 2005 19:25

yes thats why you are doing a LOCK TABLE before. Anyway my application is single user.

Ikar · Post by **Ikar** » Fri 04 Mar 2005 10:58

Your solution most likely will work.