All, Is there any way to do the following in MySQL: INSERT INTO TableName (rowID) VALUES ('max(rowID)+1') (so that the next unique identifier for the table can be determined WITHIN the insert statement?) I know MySQL provides auto-incrementing and last_insert_id. However, architecture constraints have been placed on my project that may prevent me from using these... Thanks in advance, Jason --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php