On 8/15/06, Visolve DB TEAM <[EMAIL PROTECTED]> wrote:
Hello William
Try the below Query to insert next maximum value of the field into same
table
INSERT INTO Sample(id) SELECT MAX(id)+1 FROM Sample
Wooww it works :D ... i didn't know that... great !
Wouldn't this cause a problem if more than one person were trying to insert a
record in that table at the same time? Could that not cause the ID to be the
same for 2 records
Yes. It would.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]