这看起来很简单，但我从jqGrid代码中得到了这个神秘的错误，说“元素不是表格”。这是代码:vargrid_data=[{id:"1",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},{id:"1",invdate:"2010-05-24",name:"test",note:"note",tax:"10.00",total:"2111.00"},{id:"2",invdate:"2010-05-25",name:"test2",note:"note2",ta

我尝试从这个查询中得到结果$sql="SET@col=NULL;SET@sql=NULL;SelectGroup_Concat(DistinctConcat('SUM(CASEWHENtbl.sdate=''',colname,'''THENtbl.resultELSENULLEND)AS''',colname,''''))Into@colFrom(selectconcat(month(i.invdate),'.',year(i.invdate))ascolnamefrominvoicesasiwherei.invtype=1andi.pid=5orderbyi.invdate)Asc