mysql数据库查询优化

转载于 2017-10-14 18:14:40 发布 · 306 阅读

文章标签：

#mysql

Mysql 专栏收录该内容

4 篇文章

订阅专栏

 SELECT * FROM `www.ipplus360.com`.`aiwen_free_district_v2.0.1` WHERE
INET_ATON('222.85.85.85') BETWEEN minip AND maxip LIMIT 1;



查询速度比较快：
 SELECT * FROM `www.ipplus360.com`.`aiwen_free_district_v2.0.1` WHERE 
 minip <= INET_ATON('222.85.85.85') ORDER BY minip DESC LIMIT 1;