### 关闭防火墙
systemctl disable firewalld
关闭selinux
vim /etc/sysconfig/selinux
安装环境
yum install mysql-server -y
启动服务
systemctl start mysqld
设置密码
mysqladmin -uroot password '123'
登录
mysql -uroot -p123
查看库
show databases;
建库
create database shoes
切换库
use shoes
创建表
create table shoes(id int primary key auto_incerment,product_name varchar(10),price float(8.2),color varchar(20));
数据类型
int 整型
varchar 可变长字符串类型
float 浮点型 float(5.2) 宽度5 2精度-小数点后面的位数
约束
主键:primary key
自增:auto_incerment
查询表结构
desc shoes;
插入数据
insert into shoes set product_name="nick",price=800,color="red";
查询
search * from shoes;
根据条件查询
search * from shoes where price=800;
search id,product_name,price,color from shoes where price=800;
添加字段
alter table shoes add type varchar(20);
更新记录
update shoes set type="n10086";
根据条件更新
update shoes set type="n10001" where id=1;
删除字段
alter table shoes drop color;
删除指定记录
delete from shoes where id=1;
删除所有记录
delete from shoes;
删除表
drop table shoes;
删库跑路
drop database shoes;