SELECT (@i:=@i+1) ,cc.class_date,cc.class_start_time,cc.class_end_time FROM py_class_course cc,(SELECT @i:=0)t WHERE cc.class_id=2 ORDER BY class_date DESC;
MySQL给查询结果增加序号
最新推荐文章于 2024-08-06 04:31:03 发布
SELECT (@i:=@i+1) ,cc.class_date,cc.class_start_time,cc.class_end_time FROM py_class_course cc,(SELECT @i:=0)t WHERE cc.class_id=2 ORDER BY class_date DESC;