11 2021 档案

MySQL数据中每隔几行取一条数据
摘要：select * from (select @n:=@n+1 as n, a.* from (select * from tablename order by id desc)a,(select @n:=0)b)c where c.n%2=1 limit 10 首先 ：select @n:=@n+1 阅读全文
posted @ 2021-11-04 14:16 白小白学IT 阅读(1083) 评论(0) 推荐(0)