Accueil Sujet library logo Bibliothèque Mon profil
Plus

yanhechao 2021-12-28 16:24:55

mysql 查询数据时，自动为结果编上序号

sql sql 
select (@i:=@i+1) i, username from sys_users ,(SELECT @i:=0) as i

评论

Accueil - Wiki
Copyright © 2011-2025 iteam. Current version is 2.144.0. UTC+08:00, 2025-07-10 14:44
浙ICP备14020137号-1 $Carte des visiteurs$