我如何复制连接sql表 - How can I copy JOIN-ed sql table?

How can I copy JOIN-ed sql table?

本文关键字：连接 sql 复制何复制 | 更新日期: 2023-09-27

我试过了:

INSERT INTO wp_posts_copy * (SELECT 
        *
FROM 
        wp_posts
        JOIN wp_term_relationships
                ON wp_posts.ID = wp_term_relationships.object_id
WHERE 
   wp_term_relationships.term_taxonomy_id = "48")

SQL数据库:

wp_posts => 
ID
post_author
post_date
post_date_gmt
post_content
post_title
post_excerpt
post_status
comment_status
ping_status
post_password
post_name
to_ping
pinged
post_modified
post_modified_gmt
post_content_filtered
post_parent
guid
menu_order
post_type 
post_mime_type
comment_count
wp_term_relationships =>
object_id
term_taxonomy_id
term_order

我想复制或导出那些wp_posts是在那个类别什么已经得到id 48。选择是有效的，但我不知道如何复制它们。那么，我如何复制选中的数据呢?

要从wp_posts复制列，您必须使用wp_posts.*而不是*或命名您想使用的所有列

INSERT INTO wp_posts_copy
SELECT wp_posts.* FROM wp_posts
JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id
WHERE wp_term_relationships.term_taxonomy_id = "48"