insert into 批量导入数据的案例

mysql使用基本法则  insert into table1（name,age）('mengzi',30) ，中间没有value

INSERT INTO `loan_loancontractplandetail` (
`CURRENCYID`,
`OFFICEID`,
`STATUSID`,
`INPUTTIME`,
`MODIFYTIME`,
`INPUTUSERID`,
`MODIFYUSERID`,
`COLUUID`,
`CONTRACTPLANID`,
`PLANDATE`,
`PAYTYPEID`,
`AMOUNT`,
`TYPE`,
`LASTEXTENDID`,
`LASTOVERDUEID`,
`LASTVERSIONPLANID`,
`INTERESTAMOUNT`,
`RECOGNIZANCEAMOUNT`,
`EVERYREPAYAMOUNT`,
`BUSINESSSTATUSID`,
`REPAYFORMID`,
`REPAYFORMTYPE`,
`CODE`,
`RELATEDPAYPLANID`,
`RELATEDPAYPLANCODE`,
`AUTOREPAYRESULTID`,
`ORIGINID`,
`payformid` 
) (
SELECTs.currencyid,s.officeid,1,s.MODIFYTIME,NULL,- 100,NULL,uuid( ),y.id,s.DTEND,2,s.amount - ifnull( b.amount2, 0 ),'本金',