Welcome to WebmasterWorld Guest from 54.161.228.30

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.

Thanks