数据库管理技术的产生与发展
![](https://img.haomeiwen.com/i2294180/6da39d3cee97f4a3.png)
-
人工管理,效率低成本高
image.png
-
文件系统阶段
image.png
-
数据库管理阶段
image.png
关系型数据库概念
![](https://img.haomeiwen.com/i2294180/f7a0268a0d4ee0e9.png)
![](https://img.haomeiwen.com/i2294180/b8d6cea3eec24186.png)
![](https://img.haomeiwen.com/i2294180/00611c926f669db3.png)
![](https://img.haomeiwen.com/i2294180/64fee0571966006f.png)
![](https://img.haomeiwen.com/i2294180/b0adac602571e077.png)
![](https://img.haomeiwen.com/i2294180/0b4d8af8b2d95fea.png)
![](https://img.haomeiwen.com/i2294180/09ad1b98e966154b.png)
![](https://img.haomeiwen.com/i2294180/2731f35e05a9b12b.png)
![](https://img.haomeiwen.com/i2294180/dd7405e08fa7c479.png)
![](https://img.haomeiwen.com/i2294180/4e1c2996f446cb21.png)
-
SQL
image.png
MySQL
![](https://img.haomeiwen.com/i2294180/9f344dd02477a68e.png)
![](https://img.haomeiwen.com/i2294180/92de3e34e2b883c0.png)
Mysql下载安装
![](https://img.haomeiwen.com/i2294180/29d0b9f4bbd33e19.png)
![](https://img.haomeiwen.com/i2294180/50d4b6990e915a7a.png)
![](https://img.haomeiwen.com/i2294180/90a562ac67de1bb3.png)
登录MySQL
![](https://img.haomeiwen.com/i2294180/9b5c2720f25e998e.png)
![](https://img.haomeiwen.com/i2294180/88f24b7e2a1b745f.png)
![](https://img.haomeiwen.com/i2294180/6d5848b86e25e95e.png)
![](https://img.haomeiwen.com/i2294180/09147f3698b72997.png)
![](https://img.haomeiwen.com/i2294180/a64ed77c16f4844d.png)
Navicate
数据库管理
![](https://img.haomeiwen.com/i2294180/989ad8688e5a699e.png)
-
创建数据库
image.png
-
删除数据库
image.png
MySQL数据表管理
-
Mysql数据类型
image.png
image.png
-
创建数据表
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
为列添加约束
![](https://img.haomeiwen.com/i2294180/609463b0de0d464b.png)
1、主键约束
![](https://img.haomeiwen.com/i2294180/869c67c0ffbcd8c4.png)
2、外键约束
![](https://img.haomeiwen.com/i2294180/729550196f149c69.png)
3、检查约束
![](https://img.haomeiwen.com/i2294180/ab5f7036ddaa8c8b.png)
4、默认约束
![](https://img.haomeiwen.com/i2294180/5c70324e1d916804.png)
5、自增列
![](https://img.haomeiwen.com/i2294180/c417112910b478c5.png)
查看数据表
![](https://img.haomeiwen.com/i2294180/c716316663259c03.png)
-
查看表的基本结构
image.png
-
查看表的详细结构
image.png
修改数据表
![](https://img.haomeiwen.com/i2294180/cb9834aa0748ec1f.png)
-
修改表名
image.png
-
修改字段名
image.png
-
修改字段的数据类型
image.png
-
添加和删除字段
image.png
-
增补约束
image.png
image.png
image.png
image.png
image.png
image.png
-
删除数据表
image.png
image.png
image.png
网友评论