不通

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--