MySQL从表中查找数据插入新表

-- 理论学习网上信访上线SQL

INSERT INTO szrd_article (
    title,
    sort,
    hits,
    create_by,
    create_time,
    category_id,
    category_code,
    area_code,
    is_transmit_user,
    `status`,
    article_type,
    wechart_status,
    alipay_status,
    gft_status,
    gzt_status,
    del_flag,
    link_url 
) SELECT
news.title,
news.sort,
news.hit,
news.create_by,
STR_TO_DATE( news.release_time, '%Y-%m-%d %h:%i:%s' ) AS create_time,
50 AS category_id,
'gushi' AS category_code,
'369900000000' AS area_code,
'1' AS is_transmit_user,
'1' AS `status`,
'3' AS article_type,
'1' AS wechart_status,
'1' AS alipay_status,
'1' AS gft_status,
'1' AS gzt_status,
'0' AS del_flag,
IFNULL( file.file_path, '' ) AS link_url 
FROM
    szrd_simple_news news
    LEFT JOIN biz_file_info file ON news.id = file.biz_id 
    AND file.biz_type = 'szrdNewsFile' 
WHERE
    news.news_type = '2' 
    AND news.del_flag = '0' 
    AND file.del_flag = '0';