MySQL Lists: mysql: Re: Update same table from subquery not allowed

... recno > > I need to set audit = F on the record with the max(recno) > > in most db's I would do update table set audit = f where recno = (select > max ...

lists.mysql.com