MySQL Forums
Forum List  »  Newbie

Re: Insert into db1 tbl1 from db2 tbl2
Posted by: Peter Brawley
Date: January 29, 2017 04:55PM

INSERT INTO bridge.rdata (id, pid, first, last, player)
SELECT NULL, id, first, last, player FROM polly.pdata;

Options: ReplyQuote


Subject
Written By
Posted
Re: Insert into db1 tbl1 from db2 tbl2
January 29, 2017 04:55PM


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.