MySQL Forums
Forum List  »  InnoDB

Re: help merge information
Posted by: Ryan Lowe
Date: November 18, 2008 10:16AM

Try something like the following:

UPDATE info AS i JOIN dbusers AS dbu ON (i.name = dbu.realname)
SET i.id = dbu.id;

-- Ryan Lowe

Options: ReplyQuote


Subject
Views
Written By
Posted
3003
November 17, 2008 12:24AM
Re: help merge information
2309
November 18, 2008 10:16AM
2211
November 19, 2008 01:39PM
2173
November 19, 2008 02:37PM
2189
November 20, 2008 06:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.