MySQL常用命令
MySQL
#用户管理及授权
CREATE USER luke@localhost IDENTIFIED BY 'linuxprobe';
grant all on *.* to luke@localhost;
grant select,update,delete,insert on mysql.user to luke@localhost;
#查询用户权限
show grants for luke@localhost;
#创建DB
create database linuxprobe;
#切换DB
use linuxprobe;
#创建数据表
create table mybook (name char(15),price int,pages int);
create table user (name char(20),age int ,gender char(3));
#查询数据表
show tables;
#增加数据
insert into mybook (name,price,pages) values ('linux','$30','621');
insert into user (name,age,gender) values ('wangwu','25','男');
#查询
select * from user;
select * from mybook where name="linux";
#更新数据
update user set age=28 where name="zhangsan";
#删除数据
delete from mybook;
delete from user where name="zhangsan";
#数据备份与恢复
mysqldump -u root -p linuxprobe > /root/linuxprobeDB.dump
mysql -u root -p linuxprobe < /root/linuxprobeDB.dump
#删除数据库
drop database linuxprobe;