homepage Welcome to WebmasterWorld Guest from 54.166.255.168
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
MYSQL Query - make field greater than all the others
Mysql Max
HeadBut

10+ Year Member



 
Msg#: 3959514 posted 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.

Thanks

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved