原文链接:http://dev.mysql.com/doc/refman/5.7/en/explain.html
一、语法
1. 语法格式-1
{EXPLAIN | DESCRIBE | DESC}
tbl_name [col_name | wild]
2. 语法格式-2
{EXPLAIN | DESCRIBE | DESC}
[explain_type]
{explainable_stmt | FOR CONNECTION connection_id}
原文链接:http://dev.mysql.com/doc/refman/5.7/en/explain.html
{EXPLAIN | DESCRIBE | DESC}
tbl_name [col_name | wild]
{EXPLAIN | DESCRIBE | DESC}
[explain_type]
{explainable_stmt | FOR CONNECTION connection_id}
原文链接:http://dev.mysql.com/doc/refman/5.7/en/using-explain.html
EXPLAIN
语句可以用于获取MySQL如何执行一条语句的相关信息: