WinkingJay的博客

mysql 优化sql语句的几种方法 </h1> <div class="clear"></div> <div class="postBody"> <div id="cnblogs_post_description" style="display: none"> 数据库 mysql 优化sql语句的几种方法 1、通过show sta...

https://mp.weixin.qq.com/s/ygvuP35B_sJAlBHuuEJhfg 有时间自己总结一下再写 1.ICP 2.列与主键建立联合索引 3.全文索引 4.生成列

MySQL 5.6开始支持ICP 不支持ICP时，先在存储引擎层进行索引查询，查询出的结果在server层通过其他的where条件过滤。 支持ICP时，会将where条件放在存储引擎层过滤，减少了数据扫描IO开销 show variables like ‘optimizer_switch’; set optimizer_switch = ‘index_condition_pushdown=on | off’; ...

select * from table order by id index索引 触发条件： 只扫描索引树 1）查询的字段是索引的一部分，覆盖索引。2）使用主键进行排序

select scp.*,ar.audit_unit from scheme_compile_plan scp left join audit_record ar on scp.id = ar.biz_id where ar.biz_type = #{bizType} order by ar.audit_finish_time desc limit 1)

alter table newtable default character set = utf8mb4; alter table newtable convert to character set utf8mb4;

bat文件 "D:\Program Files\mysql-8.0.19-winx64\bin\mysql.exe" -uroot -h 192.168.1.52 -p123456 gantrycranes_qqctn<"C:\Users\leohe\Desktop\deleteVesselInfo.sql">>D:\dblog.txt 2>&1 pause sql文件 USE `gantrycranes_qqctn`; delete from berth_pla.

DELIMITER $$ USE `gantrycranes_qqctn`$$ CREATE DEFINER=`root`@`%` PROCEDURE `deleteVesselInfo`() BEGIN delete from berth_plan where (TO_DAYS(NOW()) - TO_DAYS(create_time))>=15; delete from vessel_listing where (TO_DAYS(NOW()) - TO_DAYS(create_time))>