数据库安装步骤及操作表脚本

![点击Next](https://img-blog.csdnimg.cn/20190528115223798.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击Next
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115233985.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115250720.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115302573.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115313412.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115322586.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击finish![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115436354.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115449321.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115501916.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115522518.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)默认安装在C盘（注意不能有中文，或空格之类的）![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115536831.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115554803.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115611934.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)选择第三个utf8然后点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115621922.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115631569.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)这一步是设计密码，一定要记住你设得密码，然后点击next![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115645948.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)点击finish就安装完成了


找到你安装的数据库程序，双击进入，输入你设置的密码，点击回车进入



![在这里插入图片描述](https://img-blog.csdnimg.cn/2019052811570033.PNG)
创建用户
CREATE USER ‘user1’@’localhost’ IDENTIFIED BY ‘123’;
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115712610.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)创建数据库
CREATE DATABASE 数据库名称
例如CREATE DATABASE chapter03;

使用数据库
USE chapter03;
![在这里插入图片描述](https://img-blog.csdnimg.cn/2019052811572654.PNG)
创建数据表
CREATE TABLE 表名
(
	字段名1 数据类型[完整性约束条件],
	字段名2 数据类型[完整性约束条件],
…
字段名n 数据类型[完整性约束条件],
)
例 CREATE TABLE student(
		Id	INT(4),
		name	VARCHAR(20) NOT NULL,
		grade FLOAT
	);![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115738390.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)添加数据
INSERT INTO 表名(字段名1,字段名2,…)
VALUES(值1,’值2,…);
例
INSERT INTO student(id,name,grade);
VALUES(1,’zhangsan’,98.5);
查询数据
SELECT * FROM student;
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190528115753703.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x5aDE5OTgwMzI1,size_16,color_FFFFFF,t_70)更新数据
UPDATE student
set name=’caocao’,grade=50
WHERE id=1;
![在这里插入图片描述](https://img-blog.csdnimg.cn/2019052811580596.PNG)
删除数据
DELETE FROM 表名 （student）;（全部删除）
DELETE FROM 表名 [WHERE 条件表达式]（部分删除）