需求:查询mysql表中前20条数据并且分页
难点:mysql没有提供rownum
解决:
select @rownum:=@rownum+1 as rownum,id,userip,content from (select @rownum:=0)r,t_comment where @rownum<20;
需求:查询mysql表中前20条数据并且分页
难点:mysql没有提供rownum
解决:
select @rownum:=@rownum+1 as rownum,id,userip,content from (select @rownum:=0)r,t_comment where @rownum<20;