Question

求解决：将sqlserver中的SQL语句改为mysql中的SQL语句！！

String sql = " select top " +pageSize+ " * from news " + "where id not in (select top " +(pageNo - 1)*pageSize+" id from news" + " order by id desc)order by id desc";

Answer 1

mysql和sqlserver一样是支持标准sql语句的，所以这个sql语句也可以用于mysql

追问

在 top 那地方有问题 大神看看具体怎么搞？

追答

$sql = " select * from news order by id desc limit ".($pageNo - 1)*$pageSize.",".$pageSize;