我们可以重用自动生成的主键列来保存其他数据吗？

问题描述

您好我是编程新手，



我想自动生成一个sql表列。它是主键。



Incase，如果用户删除/替换数据，是否可以重新获得该（主键）字段以提高数据效率存储。





如果我错了请试着纠正我。

提前谢谢你。

Hi I am new to programming,

I want to autogenerated a sql table column. It is a primary key.

Incase, If user deletes/replaces data, is it possible to regain that (primary key)field in order to improve the efficiency of data storing.


If I am wrong then please try to correct me.
Thank you in advance.

推荐答案

Quote：

以防万一删除/替换数据，是否有可能重新获得（主键）字段以提高数据存储的效率。

In case, If user deletes/replaces data, is it possible to regain that (primary key)field in order to improve the efficiency of data storing.

你可以，但没有收获。它只是更多很复杂，因为你必须跟踪已删除的行。

You can, but there is no gain. It is just more complicated because you have to keep track of deleted rows.

这篇关于我们可以重用自动生成的主键列来保存其他数据吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！