| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor|
|MYSQL Query - make field greater than all the others|
| 3:57 pm on Jul 25, 2009 (gmt 0)|
Whats wrong with this:
Update `items` SET Adid = (SELECT MAX(Adid) From `items` WHERE 1 = 1)+1 WHERE ActNum = 1000 ;
Just want to make all the items for account 1000 have an Adid that is greater than all the others.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved