![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
文章平均质量分 64
weixin_41791956
这个作者很懒,什么都没留下…
展开
-
mysql优化
优前先首先是分析表属性与sql语句,根据情况进行优化:显示进程show full processlist \G显示语句影响explain select*from student\G explain partitions select*from student where yr in (2011,2012)\G explain extended select t1.name -> from t...原创 2018-06-04 09:58:08 · 111 阅读 · 0 评论 -
mysql-增删改
DQL selectDML insert into delete updateDDL create drop alterDCL grant revokeTPL commit rollback创建数据库-删除数据库create database 'database_1' charactor set utf8;drop database database_1;使用数据库use database_1...原创 2018-06-04 10:18:36 · 116 阅读 · 0 评论 -
mysql-查
执行顺序:from → join on → where → group by → with rollup | cube → having → select → distinct→ order by→ top | offset | fetchunion select*from `t1` where condition union [all | distinct] select*fr...原创 2018-06-04 10:39:53 · 103 阅读 · 0 评论 -
mysql-按时间查询
以下使用的字符串time为自定义名字的字段-- 今天select*from time_test where to_days(time)=to_days(now());-- 昨天select*from time_test where datediff(time,now())=-1;-- 本周select * from time_test where yearweek(date_format(time...原创 2018-06-04 10:41:14 · 1748 阅读 · 0 评论