mybatis语句批量新增语句

mybatis中语句

insert into investor_file_info (id,

userid, url, type,

uploaddate, path,

approve_id )

select SEQ_INVESTOR_FILE_INFO.NEXTVAL , A.* from(

select #{item.userId}, #{item.investorUrl}, #{item.investorType}, sysdate,

#{item.investorPath},

#{item.investorApproveId} from dual )A

oracle数据库中运⾏是下⾯这种代码insert into testcuijia(id,name,sex)select seq_home_banner.nextval,A.* from ( select '11','男' from dual union select '22','⼥' from dual) A

mysql⼀样，只是序列不⽤写了，直接⽤⾃增主键就可以insert into testcuijia(name,sex)select A.*

from ( select '11','男' from dual union select '22','⼥' from dual) A