文章浏览阅读1k次。INSERT INTO `m-auth`.`user_map_system_user` ( `system_code`, `user_id`, `click_number`, `click_time`, `order_sort`, `update_time` ) SELECT'm-accounting-integration',t.user_id,0,NOW(),1,NOW() FROM `m-auth`.`user_map_system_user` t WHERE t.syste.._mysql批量插入查询结......
文章浏览阅读2.6k次。1、MyBatis之 XML 批量删除数据public int deleteSysStudentStuIds(Long[] stuIds);<delete id="deleteSysStudentStuIds" parameterType="String"> delete from sys_student where stu_id in <foreach item="stuId" collection=......