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