Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

MYSQL Query - make field greater than all the others

Mysql Max



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.



Featured Threads

Hot Threads This Week

Hot Threads This Month