摘要:
转自美团技术博客,原文地址:http://tech.meituan.com/mysql-index.html 建索引的一些原则: 1.最左前缀匹配原则,非常重要的原则,mysql会一直向右匹配直到遇到范围查询(>、<、between、like)就停止匹配,比如a = 1 and b = 2 and 阅读全文
posted @ 2016-12-09 20:53
March On
阅读(336)评论(0)推荐(0)
摘要:
SQL语法范式: SELECT xxx FROM xxx JOIN xxx WHERE xxx GROUP BY xxx HAVING xxx ORDER BY xx LIMIT xxx FOR xxx 几个概念:statement、clause、expression statement:语句,一条 阅读全文
posted @ 2016-09-29 17:02
March On
阅读(320)评论(0)推荐(0)