Hi!
I have some troubles with my index.
I want to be able to use an index (test=(mintid, name)). I will use the
index when I write: select mintid, name from loeb;
I have created an index but it doesn't seem to work. Why?
// Chris - Copenhagen
mysql> show index from loeb;
+-------+------------+----------+--------------+-------------+-----------+--
-----------+----------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part |
+-------+------------+----------+--------------+-------------+-----------+--
-----------+----------+
| loeb | 0 | PRIMARY | 1 | id | A |
90 | NULL |
| loeb | 1 | rekord | 1 | mintid | A |
NULL | NULL |
| loeb | 1 | test | 1 | mintid | A |
NULL | NULL |
| loeb | 1 | test | 2 | name | A |
NULL | NULL |
+-------+------------+----------+--------------+-------------+-----------+--
-----------+----------+
4 rows in set (0.00 sec)
mysql> show columns from loeb;
+----------+-------------+------+-----+----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+----------+----------------+
| name | varchar(20) | | | | |
| distance | double(3,1) | | | 0.0 | |
| dato | date | YES | | NULL | |
| id | int(11) | | PRI | 0 | auto_increment |
| tottid | time | | | 00:00:00 | |
| mintid | time | | MUL | 00:00:00 | |
| art | varchar(10) | YES | | NULL | |
+----------+-------------+------+-----+----------+----------------+
7 rows in set (0.00 sec)
mysql> explain select mintid, name from loeb;
+-------+------+---------------+------+---------+------+------+-------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+-------+------+---------------+------+---------+------+------+-------+
| loeb | ALL | NULL | NULL | NULL | NULL | 90 | |
+-------+------+---------------+------+---------+------+------+-------+
1 row in set (0.00 sec)
---------------------------------------------------------------------
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
