mysql> SELECT a.user, @i:=@i+1 as id FROM user a,(SELECT @i:=0) b;
+------------------+------+
| user | id |
+------------------+------+
| hive | 1 |
| root | 2 |
| mysql.infoschema | 3 |
| mysql.session | 4 |
| mysql.sys | 5 |
+------------------+------+
5 rows in set, 2 warnings (0.00 sec)
