MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: sql dump file edit
Posted by: Barry Galbraith
Date: January 09, 2018 03:34PM

The refman for INSERT ... SELECT
https://dev.mysql.com/doc/refman/5.6/en/insert-select.html


INSERT INTO db2.pre_table (column1, column2, column3)
SELECT column1, column2, column3 from db1.table;

Good luck,
Barry.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
sql dump file edit
Donovan Brooke
January 09, 2018 11:20AM
Re: sql dump file edit
Peter Brawley
January 09, 2018 01:08PM
Re: sql dump file edit
Donovan Brooke
January 09, 2018 02:42PM
Re: sql dump file edit
Barry Galbraith
January 09, 2018 03:34PM


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.