mysql基本操作

#增
insert into msg
(id,title,name,content)
values
(1,'初来乍到','张三','刚来能不能当老大？');

insert into msg
(id,title,name,content)
values
(1,'又来了','李四','你只能千年老二');

#改
update msg
set
id = 2,
content = '偏要当老大'
where
name = '李四';

insert into msg
(id,title,name,content)
values
(3,'3标题','刘备','雌雄双剑'),
(4,'4标题','关羽','青龙偃月刀'),
(5,'5标题','张飞','丈八蛇矛');

#删除
delete from msg
where id = 2;

#查询
select name,content
from msg
where id > 2;

#查询重复
select * from vm_cpu_used where max_used_percentage < 5 group by vm_name having count(vm_name) > 3;

连接数据库：
mysql -uroot -pxxx -S /hxdata/mysql/mysql.sock

查看连接：
show processlist;

多主结构：
auto_increment_increment=2
auto_increment_offset=1

主从查看状态：
show slave status\G

赋予权限：
grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘连接口令’;
show grants for dajianrong@'192.168.204.26';