MySQL——基本语句

MySQL服务
1、mysqld状态
service mysqld status
2、开启、停止、重启
service mysqld start\stop\restart
一、数据库操作
1、创建数据库
create database databasename;
二、用户操作
1、创建用户
create user 'username'@'host' identified by 'password';
2、删除用户
delete from user where user='user_name' and host='host_name';
3、查看所有用户
select user ,host ,password from mysql.user; 
三、权限操作
1、授权
Grant all on db.* to 'user'@'hostname' identified by "pass";
2、刷新权限列表
flush privileges;
四、表的操作
1、创建表
create table sha (
     apkfile_name char(255) not null,
     sha_value mediumtext null,
     primary key (apk_filename);
自增：auto_increment
2、插入语句
INSERT INTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN );
3、清空表
delete from table_name;
truncate table table_name;
4、查看表的所有字段
desc table_name;
truncate table table_name;
show create table table_name;
5、增加列
alter table table_name add column column_name smallint null;
alter table table_name drop column column_name;
6、修改表名
alter table table_name rename to table_name_new;
7、修改列名
alter table table_name change column column_name cloumn_name_new char(255);
8、修改属性
alter table table_name modify column_name varchar(22);
9、修改主键
alter table table_name drop primary key;
alter table table_name add primary key(id);
10、设置唯一约束
create unique index index_name on table_name  ('column_name');
ADD UNIQUE KEY(resource_name, resource_type);
11、查看引擎
 show engines;
show create table 表名;
alter table table_name engine=innodb;