SELECT @rownum:=@rownum+1 AS rownum,t1.* FROM itcast_user t1,(SELECT @rownum:=0) b ORDER BY id desc
Mysql 设置数据按条件查询下的序号
最新推荐文章于 2024-01-16 16:35:39 发布
SELECT @rownum:=@rownum+1 AS rownum,t1.* FROM itcast_user t1,(SELECT @rownum:=0) b ORDER BY id desc