请问廖老师如何在指定位置插入行呢

Discuss / SQL / 请问廖老师如何在指定位置插入行呢

Back

Topic source

#1 Created at ... [Delete] [Delete and Lock User]

假如并不是想将数据插入最后一行

#2 Created at ... [Delete] [Delete and Lock User]

关系数据库的记录集没有顺序的概念，只有查询的时候才会排序。默认不指定顺序就是order by id按主键排序

#3 Created at ... [Delete] [Delete and Lock User]

可以修改相应id吗

#4 Created at ... [Delete] [Delete and Lock User]

改id没有任何意义，查询出来的可以按自己的需求排序

#5 Created at ... [Delete] [Delete and Lock User]

id再插入之后就不应该再以任何形式原因更改，楼上的前面白看了。