【MySQL】連番を振る

@iで変数定義、それをインクリメント

mysql> set @i :=0;
Query OK, 0 rows affected (0.00 sec)

mysql> UPDATE table set table_id = (@i := @i +1);
Query OK, 5277 rows affected (0.08 sec)
Rows matched: 5277  Changed: 5277  Warnings: 0

mysql> select table_id from table limit 10;
+------------------+
| table_id |
+------------------+
|                1 |
|                2 |
|                3 |
|                4 |
|                5 |
|                6 |
|                7 |
|                8 |
|                9 |
|               10 |
+------------------+
10 rows in set (0.00 sec)

mysql>