SET @num = 0;
UPDATE table SET colum = (@num := @num + 1)
mysql 更新某一列的数据为行号
最新推荐文章于 2024-03-07 14:47:31 发布
SET @num = 0;
UPDATE table SET colum = (@num := @num + 1)