Hello, I am learning MySQL and have a question. I know about the importance
of the PRIMARY KEY statement, but I also see a KEY statement being used
when creating a table. Is this just short for PRIMARY KEY, or what's the
difference?
Second question, when I have a large table, but with only 2 small cells per
row (2 columns), is it useful to create a PRIMARY KEY, KEY, or INDEX for
speed (there is no set relation to another table).
Third question, when exactly does MySQL use indexes. Is it used when the
indexed column is part of a (SELECT *) WHERE statement, together with a
non-indexed column? I just want to check if matching a row is present or
not, not actually retrieve information ("WHERE ip='$ip' and date>curdate()")
Thanks, Marco
|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
|
| Attachments only after prior notice please.
| Don't put me on any kind of mailing list.
|
| I am now receiving the Snowhite virus 4x a day
| - some of you must be infected, please check !
| (No, you did not get it from me, I use Eudora)
| __@
| _`\<,_
|__(*)/ (*)________________Ah, op DIE fiets !
---------------------------------------------------------------------
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