EXPLAIN question

Square1

Hi all:

I have a query as follows:

SELECT
SHL_PastSignings.playersID, SHL_PastSignings.player
FROM 
SHL_PastSignings
WHERE
SHL_PastSignings.player = 'jose reyes'

Why am I still getting a "type = ALL" for the EXPLAIN for this query? Why no key recommendation?:

Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => SHL_PastSignings
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 136964
    [Extra] => Using where
)

Any help appreciated

Thanks

bradgrafelman

Can you show us the schema definition (i.e. a 'SHOW CREATE TABLE' query in MySQL) for SHL_PastSignings?

johanafm

Since the only thing you could use would be an index on player and no index is used while you get a full table scan, the only thing you can do is add an index on player.

Square1

bradgrafelman;10992443 wrote:
Can you show us the schema definition (i.e. a 'SHOW CREATE TABLE' query in MySQL) for SHL_PastSignings?

I am having trouble getting out of the box on this. How do you write this?

johanafm

SHOW CREATE TABLE SHL_PastSignings;

Square1

OK, I am an idiot 😃

<?php
require($_SERVER['DOCUMENT_ROOT'].'/inc/dbconn.php');

SHOW CREATE TABLE SHL_PastSignings;

?>

johanafm

It's a SQL statement