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, SELECTis the only explainable statement.
原文:http://www.cnblogs.com/yuanjiangw/p/6230721.html