分类：查询指令

2020
09-29

MySQL explain获取查询指令信息原理及实例

explain用于获取查询执行计划信息，一、语法只需要在select前加上explain即可，如：mysql>explainselect1;+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+----------------+|id|select_type|table|partitions|type|possible_keys|key|key_len|ref|rows|filtered|Extra|+----+-------------+-------+------------+------+-----------... 继续阅读 >