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安装目录下增加一个文件目录：data3307 2、给该目录权限设为mysql.mysql， 755 3、创建数据库并初始化 /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存储引擎用的就是--MVCC MVCC最大的优点：读不加锁，读写不冲突 几乎所有的RDBMS都支持MVCC 二、