Page 1 of 1

INSERT MAX(col)

Posted: Wed Nov 16, 2005 2:09 pm
by kendall
Hello,

I have a table in which i want to INSERT a VALUE in its column(NOT AUTO_INCREMENTED) based on its MAX value

CAN this be accomplished

Note: I declined using the auto_increment for a crucial reason...see this thread

Posted: Wed Nov 16, 2005 7:18 pm
by lostboy
You can, the version of the db will dictate whether you can so it with a subselect or as two queries