MySQL Forums
Forum List  »  Newbie

Re: Transfering data
Posted by: Umesh Shastry
Date: May 26, 2005 07:03AM

Hi!!

Say table newTable exists & you want to copy/transfer data from oldTable to newTable..then try this..

INSERT INTO newTable SELECT * FROM oldTable

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221

Options: ReplyQuote


Subject
Written By
Posted
May 26, 2005 06:38AM
Re: Transfering data
May 26, 2005 07:03AM
May 26, 2005 07:03AM


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.