mysql> update dCOPY set status = '1' where dateposted = max(dateposted); ERROR 1111: Invalid use of group function mysql>
not working.. :( o btw.. i just opened another email topic, so it will be divided by topic already. thanks On Tue, 27 Jul 2004 08:04:01 +0100, Lester Caine <[EMAIL PROTECTED]> wrote: > Louie Miranda wrote: > > > now its working, > > > > i was wondering if we can do max(dateposted) on update? > > > > mysql> update datafiles set status = '1' where max(dateposted); > > ERROR 1111: Invalid use of group function > > WHERE dateposted = max(dateposted); > Perhaps ( works in Firebird :) ) > > -- > Lester Caine > ----------------------------- > L.S.Caine Electronic Services > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
