-------------- Original message from Richard Whitney <[EMAIL PROTECTED]>: -------------- > Hello! > > I have situation where I need to find the next autoindex of a table - not just > max(field) because the next autoindex may not jive with the number created by > max(field)
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html SHOW TABLE STATUS will return a field called Auto_Increment that holds the next auto increment value. There might be a more elegant way to accomplish this, but I can't remember off the top of my head. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
