Re: inserting data into a database alphabetically On 27 Oct 2004 06:12:08 -0700, Mary wrote:
>Hello, is it possible to insert new data into a datbase
>alphabetically? For example when a user enters a new row of data, I
>want the row inserted in the correct order. I do not think this is
>possible.
Hi Mary,
You are right - that is not possible. A relational table is unordered *BY
DEFINITION*.
If you need to show the results of a query in a specific order, you'll
have to use an ORDER BY clause.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address) |