mysql 自动递增更新,mysql如何通过自动增加列来更新表

最新推荐文章于 2023-12-21 15:08:42 发布

weixin_39818691

最新推荐文章于 2023-12-21 15:08:42 发布

阅读量131

点赞数

文章标签： mysql 自动递增更新

A MySql 5.3 table with 100K rows has a primary key.

There is also an integer column which is not part of the key. I would like to update this column to contain a unique number for the table. E.g. for the first record it should contain 1, for the second 2 etc.

This could as well be an auto-increment column, but MySql does not allow auto-increment on non-key columns. I don't want this column to be part of the key, because of the way it gets populated from a file etc.

So how such a query would look like?

解决方案

I don't know why do you want to do something like this, but a possible solution is this:

set @rownum:=0;

update