MySQL数据库增删查改语句

1.创建新的数据库

CREATE DATABASE database_name charset utf8;

1_1.删除数据库

drop database database_name;

1_2.查询数据库

show databases;

1_3.修改数据库

alter database database_name

2.创建数据库表

create table table_name
(
row1 type1,
row2 type2,
row3 type3
);

2_1.删除表

drop table table_name;

2_2.表查询常用指令

show tables; #查看所有表
select * from table_name; #查看所有的表数据

3.创建数据库视图

CREATE VIEW view_name 
AS
（#数据库语句）

4_1.新建数据库用户并赋权

grant ALL PRIVILEGES on database_name.* to user@'%' identified by 'password'; 
grant ALL PRIVILEGES on database_name.* to userr@localhost identified by 'password'; 
grant ALL PRIVILEGES on database_name.* to user@localhost.localdomain identified by 'password';

4_2.赋予用户查看数据库表权限

grant SELECT on database_name.* to user@'%' identified by 'password'; 
grant SELECT on database_name.* to user@localhost identified by 'password'; 
grant SELECT on database_name.* to user@localhost.localdomain identified by 'password';

4_3.收回用户权限

revoke ALL PRIVILEGES on database_name.* from user;

4_4.刷新权限

FLUSH PRIVILEGES;