mysql和postsql分页数据的区别
0表示启始行索引号=startRowIndex
40表示每页行数
//mysql
select * from tableName limit 0,40
//postsql
select * from tableName limit 40 offset 0
//获取分页数据
string page_sql = "";
if (CAPI.get_dbtype() == dbtype.mysql)
{
page_sql = sql + " limit " + startRowIndex + "," + pageSize; //mysql专用
}
else
{
page_sql = sql + " limit " + pageSize + " offset " + startRowIndex; //postsql专用
}