如何在mysql中的两个值之间插入一个新值。

I have a mySql database that contains a table have which four fields Id(primary key & auto increment), Node, Distance,pressure.

我有一个mySql数据库,其中包含一个表有四个字段Id(主键和自动增量),节点,距离,压力。

ID      Node    Distance    Pressure 
001     15       320        45
002     16       420        41
003     17       520        45
.
.
.
.
10000    256     1245        1542

The problem is that, if you want to insert a new record then the New record's ID become 10001 but I want to insert a New Record Between two records. for ex: i need to insert a new record between 001 and 002 here is the problem. I need the New record's ID as 002. currently I am solving this problem by updating tables .But it is not feasible for large number of records.

问题是,如果要插入新记录,则新记录的ID将变为10001,但我想在两个记录之间插入新记录。例如:我需要在001和002之间插入一条新记录,这是问题所在。我需要新记录的ID为002.目前我通过更新表来解决这个问题。但是对于大量记录来说这是不可行的。

2 个解决方案

#1

I don't think you can Insert a Row if ID is an auto-increment equivalent to Identity column, Considering SQL Server

如果ID是一个等同于Identity列的自动增量,我认为你不能插入一行,考虑SQL Server

Update: Also in Mysql

更新:也在Mysql中

Auto-Increment in MySQL we can't insert Row if ID is and auto-increment.

MySQL中的自动递增如果ID为自动递增,则无法插入行。

Thanks Mahmoud Gamal

感谢Mahmoud Gamal

2 个解决方案

#1

更多相关文章

随机推荐