[email protected]+1 AS id,l./ FROM sys oper log l, SELECT @i :=0 AS i limit 10 https://img blog.csdnimg.cn/20210204090340734.png?x oss process=imag...">

当前位置：网站首页>mysql在查询出来的数据前添加序号

mysql在查询出来的数据前添加序号

2022-08-09 00:13:00 【悠悠-我心】

示例如下

SELECT (@i :[email protected]+1) AS id,l.* FROM sys_oper_log l,(SELECT @i :=0) AS i limit 10

版权声明
本文为[悠悠-我心]所创，转载请带上原文链接，感谢
https://blog.csdn.net/liu_yulong/article/details/113624164

边栏推荐

猜你喜欢