mysqlinsert存在即不插入语法说明

replace into table(id, name) values(1, '张三') ;

replace into table(id, name) select 1, '张三' ;

insert into table(id, name)
select null, '张三' from DUAL
where not exists (select id from table where name = '张三') ;

insert into table(id, name) on duplicate key update name = '李四';

INSERT INTO agent_user (group_id,group_type,user_name, user_mobile,created_time,updated_time)
SELECT 9503,8,a.user_name,a.user_mobile,1642397508000,1642397508000
from agent_user_heimingdan a on DUPLICATE KEY UPDATE user_mobile = a.user_mobile;