V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 2214 days ago, the information mentioned may be changed or developed.
语句 a: SELECT * FROM bbs_topic topic WHERE topic.content LIKE "%蜜蜂%" LIMIT 1, 20;
语句 b: SELECT * FROM bbs_topic topic WHERE topic.content LIKE "%蜜蜂" LIMIT 1, 20;
语句 c: SELECT * FROM bbs_topic topic WHERE topic.content LIKE "蜜蜂%" LIMIT 1, 20;
字段 content 没有加索引,分析执行计划都一样,为什么执行时间 a<c<b?
 |
1
Vegetable Apr 8, 2020
可能和有样本本身有关系? 先取到 20 条的自然就先结束了.
|
Select Language