先看看具体有哪些字段:mysql>EXPLAINSELECT1;其实除了以SELECT开头的查询语句,其余的DELETE、INSERT、REPLACE以及UPDATE语句前边都可以加上EXPLAIN这个词儿,用来查看这些语句的执行计划建两张测试表:CREATETABLEt1(idINTNOTNULLAUTOINCREMENT,key1VARCHAR(100),key2VARCHAR(100),key3VARCHAR(100),nameVARCHAR(100),PRIMARYKEY(id),KEYidxkey1(key1),KEYidxkey2key3(key2,key3))EngineInnoDBCHARSETutf8;CREATETABLEt2(idIN...