错误信息提示:
错误号:12142

错误原因:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `Order` ASC, `ID` DESC ) a,( select @rowNO :=0 ) b ) c WHERE ID=42' at line 1

错误SQL语句:
select rowno from ( select (@rowNO := @rowNo+1) AS rowno, ID from ( SELECT ID FROM lxkj_archives where ViewFlagCh and SortID= ORDER BY `Order` ASC, `ID` DESC ) a,( select @rowNO :=0 ) b ) c WHERE ID=42


错误信息提示:
错误号:12142

错误原因:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `Order` ASC, `ID` DESC ) a,( select @rowNO :=0 ) b ) c WHERE rowno = -1' at line 1

错误SQL语句:
select * from ( select (@rowNO := @rowNo+1) AS rowno, ID, Title_Ch, a.`Order` from ( SELECT ID, Title_Ch, `Order` FROM lxkj_archives where ViewFlagCh and SortID= ORDER BY `Order` ASC, `ID` DESC ) a,( select @rowNO :=0 ) b ) c WHERE rowno = -1


错误信息提示:
错误号:12142

错误原因:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `Order` ASC, `ID` DESC ) a,( select @rowNO :=0 ) b ) c WHERE ID=42' at line 1

错误SQL语句:
select rowno from ( select (@rowNO := @rowNo+1) AS rowno, ID from ( SELECT ID FROM lxkj_archives where ViewFlagCh and SortID= ORDER BY `Order` ASC, `ID` DESC ) a,( select @rowNO :=0 ) b ) c WHERE ID=42


错误信息提示:
错误号:12142

错误原因:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `Order` ASC, `ID` DESC ) a,( select @rowNO :=0 ) b ) c WHERE rowno = 1' at line 1

错误SQL语句:
select * from ( select (@rowNO := @rowNo+1) AS rowno, ID, Title_Ch, a.`Order` from ( SELECT ID, Title_Ch, `Order` FROM lxkj_archives where ViewFlagCh and SortID= ORDER BY `Order` ASC, `ID` DESC ) a,( select @rowNO :=0 ) b ) c WHERE rowno = 1


田叶老师

当前位置:
首页 >
错误信息提示:
错误号:12142

错误原因:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and ViewFlagCh ORDER BY `Order` ASC, `ID` DESC' at line 1

错误SQL语句:
SELECT * FROM lxkj_columanage where (ParentID=) and ViewFlagCh ORDER BY `Order` ASC, `ID` DESC


田叶老师

2020-12-30 45