Hi, Is there any way to automatically update several rows as a result of a change to information being changed in another row in the same table?
|------|-------| | NAME | VALUE | |------|-------| | ABCD | 10 | | DEFG | 12 | | HIJK | 11 | |------|-------| So if I changed DEFG to 11, how would I swap the value with that of HIJK or swap ABCD with DEFG? Thanks, Mumba ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
