Detailed explanation of Mysql
explain field description
Adding explain in front of the sql statement to be executed can simulate the execution process of the statement by the optimizer. Example description: explain select * from sys_user; explain will return one or more pieces of data. The meaning of each column is explained below:
1. id execution order.
This is a relat ...
Posted by perrohunter on Wed, 02 Mar 2022 04:13:01 +0100
MySQL SQL optimization explain analysis
explain analysis execution plan
You can use the EXPLAIN or DESC command to obtain information about how MySQL executes the SELECT statement, including how tables are connected and the order of connection during the execution of the SELECT statement.
Execution plan of query SQL statement:
explain select * from tb_item where id = 1;
...
Posted by xtian on Fri, 01 Oct 2021 20:48:40 +0200