mysql数据库查询优化

来源:互联网 发布:广西广电网络三网合一 编辑:程序博客网 时间:2024/05/30 23:06
 SELECT * FROM `www.ipplus360.com`.`aiwen_free_district_v2.0.1` WHEREINET_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;
原创粉丝点击