Re: Help with INSERT & Subquery

Could you possibly bump up the counter in table 3 prior to inserting the data from table 1?

On Tue, 08 Aug 2000 17:07:55 GMT, pmurnane_at_usa.net wrote:

>For NeedHelpHere, my first thought was to SELECT MAX(column1)+1 FROM
>table2, then UPDATE table3 SET column = (SELECT MAX(column1)+1 FROM
>table2). But since the commit isn't done until after the entire INSERT
>has run, I got unique index violations.
Received on Wed Aug 09 2000 - 00:00:00 CDT