介绍前文已经说了explain命令的大部分参数,接着图解:EXPLAIN实战1这篇文章把explain的keylen参数分享完,接着分享最左前缀原则,建立如下的表,其中name列和address列都建立了索引CREATETABLEteacher(idint(10)NOTNULL,namechar(20)NOTNULL,addressvarchar(100)DEFAULTNULL,PRIMARYKEY(id),KEYidxname(name),KEYidxaddr(address))ENGINEInnoDBDEFAULTCHARSETutf8;执行如下命令explainselectfromteacherwherename"张三"explain...