这个Oracle语句转成 mysql语句怎么写 ，我每次运行都有错误

Question

select * from (select rownum rn,g.*,c.name cname from shop_goods g,shop_category c where g.categoryid=c.id

and g.categoryid=#{categoryid}



and g.name like #{name}

) r
where r.rn between (#{page}-1)*#{pageSize} and #{page}*#{pageSize}

Answer 1

将里面的rownum去掉，里面的查询使用limit，不需要外面的嵌套就行了

 select g.*,c.name cname from shop_goods g,shop_category c where g.categoryid=c.id
and g.categoryid=#{categoryid} and g.name like #{name} limit  index,pagesize