MySQL Forums
Forum List  »  Newbie

Need help with select and update
Posted by: Hanns-Christian Nicken
Date: April 14, 2008 02:37AM

Hi guys,

I am new here and have not been a regular sql-user so far. I have to do a special job on my mysql database:

On the table ADRBOOKCONTACT, I have to find all entries, where SURNAME empty is and NAME not empty is,

then I have to copy the data from NAME to SURNAME and delete the contents of Name.

Can you please help me with the select?

Thank you,

Chris

Options: ReplyQuote


Subject
Written By
Posted
Need help with select and update
April 14, 2008 02:37AM


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.