select (@rowNo:=@rowNo + 1) AS rowNo,tt.* from (
SELECT
t.id,
t.NAME,
t.district,
t.licnum,
t.creditcode,
t.contact,
t.phone,
t.tracarnum,
t.safmngnum,
t.addtime
FROM
ods_dsznh_t_training_driverschool t
) tt , (SELECT @rowNo := 0) v
ORDER BY tt.addtime desc
Mysql查询结果列表序号
最新推荐文章于 2024-05-13 15:11:49 发布