mysql使用sql语句同步数据

最新推荐文章于 2024-09-07 22:45:56 发布

青梅煮酒吃花生米

最新推荐文章于 2024-09-07 22:45:56 发布

阅读量1.2k

点赞数

文章标签： mysql sql 数据库同步 java

本文链接：https://blog.csdn.net/hellowangchaochao/article/details/76315257

版权

使用sql语句同步源表和目标表的指定地段

INSERT INTO yl_customer_info(customer_name,customer_level,customer_type)

SELECT customer_name,customer_level,customer_type

FROM yl_customer_info_copy

使用IGNORE关键字，如果遇到重复，不会操作当前行

INSERT IGNORE INTO yg_company_info(company_name,tel,company_type,province,city,district,address,ruins_code,ruins_price,price_unit,yyzz_url,create_time,create_user_id,create_user_name)
SELECT company_name,tel,customer_type,province,city,district,address,big_ruins_code,ruins_price,runis_price_unit,certificate1,create_time,create_user_id,create_user_name
FROM yl_customer_info s
WHERE s.register_date BETWEEN '2017-07-31' AND '2017-08-25'