mysql 根据条件update、创建、替换整理

UPDATE wjy_custom AS c
INNER JOIN (
    SELECT
        a.id 
    FROM
        wjy_custom a
        LEFT JOIN wjy_custom_remark b ON a.id = b.custom_id 
    WHERE
        a.charge = 71 
        AND a.status = 0
    GROUP BY
        a.id 
    HAVING
        count( b.id ) > 0 limit 0, 187 更新的条数
    ) AS d 
    SET charge=24,status=1#要更新的字段
WHERE
    c.id = d.id

替换：

REPLACE INTO `db_yjh`.`yjh_form_logs` (`id`, `info_id`, `info_type`, `info_path`, `duration`, `add_time`, `user_id`, `device_id`, `page_type`, `end_time`, `pid`, `platform`, `shop_id`, `top_user_id`, `module_type`, `cat_id`, `cat_pid`, `province`, `ip_province`, `mobile_province`, `created`)
select `id`, `info_id`, `info_type`, `info_path`, `duration`, `add_time`, `user_id`,
 `device_id`, `page_type`, `end_time`, `pid`, `platform`, `shop_id`, `top_user_id`, `module_type`, `cat_id`, `cat_pid`, `province`, `ip_province`, `mobile_province`, `add_time`
from db321.sline_xsct_stroll_logs;

创建：

# 拨打电话表
INSERT INTO `db_yjh`.`yjh_phone_call` (`id`, `mall_id`, `calling_phone`, `called_phone`, `user_id`, `created`, `datetime`, `modified`)
select `id`, `mall_id`, `calling_phone`, `called_phone`, `user_id`, `add_time`, `datetime`, `modified`
from `db321`.`sline_phone_call`;