Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Database Record Order

by edoc (Chaplain)
on Dec 30, 2003 at 22:20 UTC ( #317794=note: print w/replies, xml ) Need Help??

in reply to Database Record Order

The data, which perl outputs isn't in the same order as the database.

The database has no inherent order. You must consider query results as being returned from the database in random order (much like keys from a hash) unless you specify an 'order by' clause.



Replies are listed 'Best First'.
Re: Re: Database Record Order
by monktim (Friar) on Dec 31, 2003 at 14:12 UTC
    That depends on the DBMS you are using. When the ORDER BY clause is not specified, some dBs return the data in the order it was inserted into the tables. You'll have to read your dB's documentation to be certain.
      If this is an MS-SQL server then the "default" order is likely to be the order of the clustered index. However, relying on that ordering when using an RDBMS is unwise, as it could change at any time, or be different if you move your script from one type of database server to another, or if other DDL changes (such as different indexes, different locking methods, etc) are applied.

      In short - never rely on the order of data in a SELECT without an ORDER BY clause.


Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://317794]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2023-02-01 23:12 GMT
Find Nodes?
    Voting Booth?
    I prefer not to run the latest version of Perl because:

    Results (15 votes). Check out past polls.