Re: showing warnings
| From: | Niel Archer | Date: | Tue, 11 Sep 2007 09:31:01 +0000 |
| Subject: | Re: showing warnings | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43991@lists.php.net to get a copy of this message | ||
>
> mysql> explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
> +--------------+------+---------------+------+---------+------+------+-------+
> | table | type | possible_keys | key | key_len | ref | rows |
> Extra |
> +--------------+------+---------------+------+---------+------+------+-------+
> | Mobile_Tunes | ALL | NULL | NULL | NULL | NULL | 4 |
> |
> +--------------+------+---------------+------+---------+------+------+-------+
> 1 row in set (0.00 sec)
> mysql>
This shows you have NO indexes on the table. Assuming that 'Tune_Name'
contains unique entries for each row, I'd suggest you do the following
as a minimum:
ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name);
--
Niel Archer