MySQL常用命令

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

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;