Mysql 常用命令

Mysql 常用命令汇总

数据库:

显示数据库  show databases 
创建数据库  create database DatabaseName;
选择数据库  use DatabaseName;
删除数据库  drop database DatabaseName;

刷新数据库  flush privileges;

用户：

创建用户：  create user UserName identified by Password;

删除用户：  delete from user where user='UserName' and host = '%' ;

修改密码：  update user set password=password("Password") where user ='UserName';

赋连接权限：grant usage on DatabaseName.TableName  to  UserName ;

赋操作表权限： grant [ select / delete / update / insert / create / drop ] on DatabaseName.TableName  to  UserName ;

删除授权:： revoke all privileges on *.* from UserName ;

表:

显示表：    show tables;
重命名表：  alter table TableName1 rename TableName2;

增删改查:  增加: insert into TableName(RowName)  values (row1Value,row2Value); 删除: delete from TableName where rowName = rowValue ; 修改: update TableName set=rowValue where rowName=?;  查询:  select  rowName [*] from TableName [where rowName = rowValue ];