mysql创建视图报错[Err] 1353 - View's SELECT and view's field list have different column counts

主要错误原因就是括号里面的字段和查询出来的字段不一一对应

CREATE VIEW `v_breedlogtop`(youngId,strName,farmId,strAddress,strPhoneId,produceName,iCycCount,dtOccur,iBuiNum,iCount,iGivCount) AS
select
   Young.ID youngId,
   TermUser.strName strName,
   Farm.ID farmId,
   Farm.strAddress strAddress,
   TermUser.strPhoneId strPhoneId,
   Produce.ProduceName produceName,
   YouComInfo.iCycCount iCycCount,
   YouComInfo.dtOccur dtOccur,
   Building.iBuiNum iBuiNum,
   Young.iCount iCount,
   Young.iGivCount iGivCount
from
   TermUser,
   Farm,
   Building,
   YouComInfo,
   Young,
   Author,
   Produce
where
   Farm.ID = YouComInfo.FarmId
   and YouComInfo.ID = Young.iYouComInfoId
   and Farm.ID = Building.iFarmId
   and Farm.ID = Author.FARM_ID
   and TermUser.ID = Author.AUTHORED_ID
   and Produce.ID = YouComInfo.iProId
   and Building.ID = Young.iBuiId
group by
   Young.ID