Welcome to WebmasterWorld Guest from 54.226.2.31

Forum Moderators: open

Message Too Old, No Replies

MYSQL Query - make field greater than all the others

Mysql Max

     

HeadBut

3:57 pm on Jul 25, 2009 (gmt 0)

10+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month