MySQL8&MySQL5 行号

 MySQL8 可以用函数 ROW_NUMBER() OVER (ORDER BY 列名) row_num

SELECT 
ROW_NUMBER() OVER (ORDER BY productName) row_num,
productName
FROM products 
ORDER BY productName

MySQL5 可以用 @rownum 变量来实现 (MySQL5没有ROW_MUNBER()函数)

SELECT
(@rownum := @rownum + 1) row_num,
a.productName
FROM products a,(SELECT @rownum := 0) r
ORDER BY productName

 当然, 这个也适用于MySQL8

---

实际应用, 将行号写入某一列:

with hf 
as(
	SELECT (@rownum := @rownum + 1) row_num,a.* FROM iec104_eq a,(SELECT @rownum := 0) r ORDER BY a.eq_address,a.eq_table
)
update iec104_eq a left join hf b on a.eq_uuid=b.eq_uuid
set a.eq_address =b.row_num