Welcome to WebmasterWorld Guest from 54.167.102.69

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)

Junior Member

10+ Year Member

joined:Sept 2, 2004
posts:187
votes: 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