Home Topic library logo Library Mine
More

yanhechao 2021-12-28 16:24:55

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

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

评论

Home - Wiki
Copyright © 2011-2024 iteam. Current version is 2.137.1. UTC+08:00, 2024-11-21 01:42
浙ICP备14020137号-1 $Map of visitor$