W wxdqz New Member Aug 21, 2008 #1 Does anybody know a method of updating a sinlge value where the id=MAX(id) The following query does not work, and it appears the mySQL does not allow the ORDER BY for UPDATE. UPDATE table SET foo='value' ORDER BY id DESC LIMIT 1 Thanks
Does anybody know a method of updating a sinlge value where the id=MAX(id) The following query does not work, and it appears the mySQL does not allow the ORDER BY for UPDATE. UPDATE table SET foo='value' ORDER BY id DESC LIMIT 1 Thanks
