does not matter you are signed up for this mailing list, to unsubscribe
send an email to [EMAIL PROTECTED] with any subject or
text message your heart desires, but make sure you use the email that you
are subscribed with on the mailing list
On Wed, 31 Jan 2001, Ha Linh Don wrote:
> HEllo,
>
> My name is Don , but I am not interested in "msql". May be , you are
> confused me
> with another person who is expert in database.
>
> Please remove me out of your mail list
>
> Thanks
>
> -----Original Message-----
> From: Dan Nelson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 26, 2001 11:45 PM
> To: Don
> Cc: msql list
> Subject: Re: Are index file only for querying?
>
>
> In the last episode (Jan 26), Don said:
> > I have a table called Ports that contains Port information and has
> > several columns. I've designated the Portname column as Primary as
> > it is unique (I did not specify it as unique). When I do a:
> >
> > SELECT * FROM Ports;
> >
> > It does NOT show the table contents in index order (Portname
> > beginning with "A" all the way through "Z") but rather in the order
> > they were entered.
>
> SQL tries to give you your results as fast as possible. Indexes are
> used when they can help. They cause more disk I/O though, so if MySQL
> determines that a query will read more than 10% (I think) of the
> records in a table, it simply drops to a full table scan.
>
> > So, it seems to me that indexes are only used for querying. If I run
> > through the data or issue the above SELECT statement, how do I
> > display my rows in Primary Key order?
>
> SELECT * FROM Ports ORDER BY Portname;
>
>
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
