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
Thanks
Visolve DB Team
----- Original Message -----
From: "William DeMasi" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, August 15, 2006 12:34 AM
Subject: Incrementing using Max(Field) ?
Does anyone have any ideas of how I can select the max value and insert
the
next highest value?
I want something that would do something like this:
Insert into table1 (select max(field1)+1 from table1);
This obviously doesn't work.
I know if the table was set to auto-increment it wouldn't be an issue, but
I
am not able to change its schema.
Thank you.
- William
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
