- 博客(6)
- 收藏
- 关注
原创 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 1747
原创 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 99
原创 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 112
原创 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 103
原创 vm下安装centos
1. 加入強制使用 GPT 分割表inst.gpt2.biosboot 2m root 2g swap 3g 剩下看着来3.更换国内yum源cd /etc/yum.repos.dmv CentOS-Base.repo CentOS-Base.repo.backupwget -O /etc/yum.repos.d/CentOS-Base-aliyun.repo http://mirrors.al...
2018-06-04 09:32:05 103
原创 正则表达式
[:alnum:]0-9,A-Z,a-z[:alpha:]A-Z,a-z[:blank:] ,tab[:cntrl:]CR,LF,Tab,Del...[:digit:]0-9[:graph:]except and Tab[:lower:]a-z[:upper:]A-Z[:print:]任何能被打印出来的字元[:punct:]punctuation symbol[:space:] ,Tab,CR[...
2018-06-04 09:28:04 87
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人