Thank you very much! -----Original Message----- From: Visolve DB TEAM [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:44 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Incrementing using Max(Field) ?
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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
