不通

來源: f64 於 2004-01-12 17:05:00 [] [舊帖] [給我悄悄話] 閱讀數 : (547 bytes)
本文內容已被 [ f64 ] 在 2004-02-06 15:24:48 編輯過。如有問題，請報告版主或論壇管理刪除.

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--
請您先登陸，再發跟帖！