v587_lu的博客

创建用户：update user set password=password('123456') where User='jira'赋予权限：grant all privileges on *.* to 'jira'@'%' identified by '123456' with grant option; 上条语句中: ‘jira’ 表

1、在使用group by 查询一张表的数据的时候：select date,time,max(delaytime) as delaytime,sum(delaynum) as delaynum, max(onlineCount) as onlineCount,sum(perMinuteVerify) as perMinuteVerify,auditor from verifyDelayLog WH

1、在mysql安装目录下增加一个文件目录：data33072、给该目录权限设为mysql.mysql， 7553、创建数据库并初始化/usr/local/mysql5.6/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql5.6 --datadir=/usr/local/mysql5.6/data330

一、名词解析：RDBMS:：Rational Database Management System 即关系型数据库管理系统MVCC：Multi-version Concurrency control 多版本并发控制协议Mysql Innodb存储引擎用的就是--MVCCMVCC最大的优点：读不加锁，读写不冲突 几乎所有的RDBMS都支持MVCC二、