SEO

#1 (**permalink**) 02-29-2008, 04:40 AM

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.

Thank you for the help!

#2 (**permalink**) 02-29-2008, 04:40 AM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

inserting data into a database alphabetically