这是正常的格式:
mysql>explain select * from table;
+----+-------------+-------+------+---------------+------+---------+------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+------+-------+
我看到书上有下面这种显示方式,请问下面这种方式怎样设置出来的?
mysql> EXPLAIN SELECT artist_id, type, founded
-> FROM artist
-> WHERE name = 'Coldplay'\G
********************* 1. row ***********************
id: 1
select_type: SIMPLE
table: artist
type: ref
possible_keys: name
key: name
key_len: 257
ref: const
rows: 1
Extra: Using where
胡子哥哥