Perhaps you could use an autoincrement field?

[EMAIL PROTECTED] wrote:

I would like to do the following:

INSERT INTO tt (a,i) VALUES ('text',MAX(i)+1);

This doesn't work b/c MAX() isn't allowed here. Does
anyone know how I can still achieve this with ONE
query?

Thanks.

Dan






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



Reply via email to