[ale] Getting the next index of a table in mysql

[hpassau at emory.edu (Billy Passauer)]

Chris Fowler wrote:
>>Checking the new Row ID after an insert is the only real way to go
>> about it.
> 
> This might be the best way but how do I do this?  "select serial_no from
> table_533 where ....."

See
MySQL Reference Manual :: 24.2.13.3 How to Get the Unique ID for the 
Last Inserted Row

http://dev.mysql.com/doc/mysql/en/getting-unique-id.html