View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 04:40 AM
Hugo Kornelis
 
Posts: n/a
Default 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)
Reply With Quote