Question

帮忙把sql server语句 转成 mysql语句

select top 20 * from TBL_TOPIC where boardId="+boardId+" and topicId not in(select top "+rowBegin+" topicId from TBL_TOPIC where boardId="+boardId+" order by publishTime desc)order by publishTime desc

Answer 1

估计你这是分页搜索吧
查询topicid从rowbegin开始以后20条数据
mysql查询可以使用limit rowbegin,20

"select * from TBL_TOPIC where boardId="+boardId+" order by publishTime desc limit rowBegin,20"