Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'from'. Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'order'.
网上是这样的,我想实现个分页功能 //判断起始页 ipage = 6; //每页6条记录 .. //cpage当前页 spage=(cpage-1)*ipage; //spage开始页sql = "select * from tb_merchant_type order by a_id desc limit "+ spage +","+ ipage; rs = sqlconn.executeQuery(sql);
MYSQL POSTGRESQL里面有这样的 关键字
select * from user limit 1 select * from user limit 2,1 mysql里面的用法sqlserver 里面用的是top n oracle里面用的是rownum
Incorrect syntax near the keyword 'from'.
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'order'.
//判断起始页
ipage = 6; //每页6条记录
.. //cpage当前页
spage=(cpage-1)*ipage; //spage开始页sql = "select * from tb_merchant_type order by a_id desc limit "+ spage +","+ ipage;
rs = sqlconn.executeQuery(sql);
select * from user limit 2,1
mysql里面的用法sqlserver 里面用的是top n
oracle里面用的是rownum