不通

来源: f64 于 2004-01-12 17:05:00 [] [旧帖] [给我悄悄话] 阅读数 : (547 bytes)
本帖于 2004-02-06 15:24:48 时间, 由普通用户 old-cotton 编辑

What is a table? A table is set of rows. A set is a bunch of similar items not in any particular order. So the rows in a table are not in any particular order. Your "row number" is just for database engine's internal use to keep track of the row in physical storage.

If you want the rows in a certain order, and a column called "line number" before you import them from a text/spreadsheet into the db. The "row number" is not stable. You reindex the table, it will change. you update the table cause page split, the row number will change.



--文学城www.wenxuecity.com--
请您先登陆，再发跟帖！