SHOW VARIABLES LIKE '%version%';
https://dev.mysql.com/doc/refman/5.6/en/explain.html
As of MySQL 5.6.3, permitted explainable statements for EXPLAIN
are SELECT
, DELETE
, INSERT
, REPLACE
, and UPDATE
. Before MySQL 5.6.3, SELECT
is the only explainable statement.