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` 
) (
SELECT
	s.currencyid,
	s.officeid,
	1,
	s.MODIFYTIME,
	NULL,- 100,
	NULL,
	uuid( ),
	y.id,
	s.DTEND,
	2,
	s.amount - ifnull( b.amount2, 0 ),
	'本金',