如何在mysql中为字段id插入自动编号?我已经有一个名为
idmember
的主键。
以下是我尝试过的代码,请进行更正。UPDATE member SET id = Row_number()over ORDER BY idmember
You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'over order by idmember' at line 1