Re: Incrementing using Max(Field) ?

[obed]

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 !

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]