MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: SQL code to take specific rows from one table and overwrite them in another
Posted by: John Mitchell
Date: May 11, 2021 04:42PM

Thank you, much appreciated.

I need to ensure that only specific records are copied across from the one table (dbugxamc7km01t.i8qMCzNt9_posts) to the other table (dbqa71w2mfxarx.i8qMCzNt9_posts). The records that need copying across are all records WHERE post_type = "page". How do i update the SQL statement to include that criteria?

Kind regards,

John

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


Subject
Written By
Posted
SQL code to take specific rows from one table and overwrite them in another
John Mitchell
May 10, 2021 01:36PM
Re: SQL code to take specific rows from one table and overwrite them in another
Peter Brawley
May 10, 2021 03:01PM
Re: SQL code to take specific rows from one table and overwrite them in another
John Mitchell
May 11, 2021 04:42PM
Re: SQL code to take specific rows from one table and overwrite them in another
Peter Brawley
May 11, 2021 08:02PM


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.