不通

来源: f64 于 2004-01-12 17:05:00 [] [旧帖] [给我悄悄话] 阅读数 : 0 (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--
请您先登陆，再发跟帖！