如何给自定义表导入另外一个数据库的表的部分字段

-- Make sure you're in the WordPress database
USE your_wordpress_database_name;

-- Import data from the wz_enquiry table to wp_feedback_submissions
INSERT INTO wp_feedback_submissions 
(submission_date, siteid, pagename, pageurl, customer, email, company, phone, content)
SELECT 
    IFNULL(add_time, NOW()) as submission_date,
    IFNULL(CONVERT(siteid, CHAR), '') as siteid,
    IFNULL(pagename, '') as pagename,
    IFNULL(pageurl, '') as pageurl,
    IFNULL(customer, '') as customer,
    IFNULL(email, '') as email,
    IFNULL(company, '') as company,
    IFNULL(phone, '') as phone,
    IFNULL(content, '') as content
FROM other_database_name.wz_enquiry;