mysql insert into

给所有角色ID不是１的用户全部增加一条角色ID＝１的记录

insert into peppa.employee_role (role_Id,employee_Id) 
select 1,id from peppa.employee t where t.id not in(select employee_id from peppa.employee_role t1  where t1.role_id=1)

xxljob任务复制

SELECT id, 38 as job_group, job_cron, job_desc, add_time, update_time, author,
alarm_email, executor_route_strategy, executor_handler, executor_param, 
executor_block_strategy, executor_timeout, executor_fail_retry_count, 
glue_type, glue_source, glue_remark, glue_updatetime, child_jobid
FROM `xxl-job`.xxl_job_qrtz_trigger_info where job_group=36;

delete from `xxl-job`.xxl_job_qrtz_trigger_info where job_group=37;

insert into `xxl-job`.xxl_job_qrtz_trigger_info
(job_group, job_cron, job_desc, add_time, update_time, author, alarm_email, 
executor_route_strategy, executor_handler, executor_param, executor_block_strategy, 
executor_timeout, executor_fail_retry_count, glue_type, glue_source, glue_remark, glue_updatetime, child_jobid )
select 38, job_cron, job_desc, add_time, update_time, author, alarm_email, 
executor_route_strategy, executor_handler, executor_param, executor_block_strategy, 
executor_timeout, executor_fail_retry_count, glue_type, glue_source, glue_remark, glue_updatetime, child_jobid 
from `xxl-job`.xxl_job_qrtz_trigger_info
where job_group=37;