插入数据时忽略重复的key
https://blog.csdn.net/qq_27517377/article/details/85159047
INSERT INTO syadmin_db.datam_histvalue
(hist_date, unit_value, re_value, parent_prod_id) VALUES
('20200207', 1.3365, 1.3511, 5),
('20200125', 1.3365, 1.3511, 5) on duplicate key update id = id;
1
2
3
4
5
2
3
4
5
编辑 (opens new window)
上次更新: 2021/10/11, 12:43:58