如何查询mysql中执行效率低sql语句.docVIP

配置f/my.ini，增加 --log-slow-queries 配置，记录所有的slow query，然后挨个优化 本文来源于 WEB开发网 原文链接： HYPERLINK /mysql/3573.htm /mysql/3573.htm select @a=DRClass1, @b=DRClass2, @c=DRClass3, @d=DRClass4, @e=DRClass5 from Teacher Where TeacherID = @TeacherID create table classname(classname char(50)) insert into classname (classname) values (@a) if (@b is not null) begin insert into classname (classname) values (@b) if (@c is not null) begin insert into classname (classname) values (@c) if (@d is not null) begin insert into classname (classname) values (@d) if (@e is not null) begin insert into classname