MySQL之初识MySQL、操作数据库
1、初识MySQL
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_y2vBxOWlXOeYZJIEEKj0kA.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_ojRxO2TyRMBBXTOKiiucfA.png)
1.1、为什么学习数据库
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_5Bbvh5wwLskrtGkrEWUMrw.png)
1.2、什么是数据库
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_aOBzdNzRdhUY0tM1ggeuHQ.png)
1.3、数据库分类
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_gJfp4rkpGLQaycX1f8qMWw.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_McaRPFpmJXDrcEAa3iay9g.png)
1.4、MySQL简介
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG__QvEbu6u8xpC2N7AEv9Kxw.png)
官网:https://www.mysql.com/
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_GeQ7gQ1Vy-H1PS33HQRw-w.png)
1.5、安装MySQL
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_NgY1JvfKltFQElUNQsS0ng.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_3BAYN4ZOrqiEwI7lu2WdrQ.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_4YxErExYdt37swqu8EGUTQ.png)
问题:
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_jOSLKxpTkdmQsrhTHD6-xg.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_mudl4PVVNbz0t0nfRjgR6w.png)
1.6、安装SQLyog
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_XL2x7-YMudGpQBmjysvqCQ.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_Q_6gDDNMDq7fXzxTWPJKqw.png)
- 新建一个数据库 school
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_vtmJLt-HFjwlC7PyOkEQhg.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_LxU9HWRjLj8WGui4EA428Q.png)
新建一张表 student
字段: id,name,age
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_NY03lMFOzmbTxxU7qLE9OA.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_MePg3Ehun1VscekVkcrCmQ.png)
1.7、连接数据库
命令行连接!
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_5zaD-aR-OIpdme8mqWuusw.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_hgOrjjkl3_P6VwwZvFdp4w.png)
2、操作数据库
操作数据库 > 操作数据库中的表 > 操作数据库中表的数据
mysql关键字不区分大小写
2.1、操作数据库(了解)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_wX2hkBRzg4LMRPXfg2_kew.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_Ft2HaC2V3mrEbAC48SD9Og.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_mutV97NLKw1Rfo9zYhIFBA.png)
2.2、数据库的列类型
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_fY-Y9Dy-0YjEnKlMLBT00Q.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_a3bN7Iuzn2BDsYzA1Ddjnw.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_URiXdY2BCAZ5tOSx8vJmMg.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_2UHg-xvwSq_x9Cu3GL_OXQ.png)
2.3、数据库的字段属性(重点)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_WQB7zghG-XpDG-ITBwsrdg.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_xCrzFXF888BzRj6uoiInsw.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_Un2_W8Z-kPaIsm-3Cl5MwQ.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_nelU1qBj5efxn-RldT9hRA.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_FC443DQvE8PcwxPRi-cecg.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_RkTJ10WNEA_EMEcG7YRufA.png)
2.4、创建数据库表(重点)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_T8rRvK20r_BRBLc9ErJoNA.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_IGS8SRT9YRRwPArcOAAolw.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_iF_ApNOQNNXGvfZTy0hoxQ.png)
2.5、数据表的类型
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_nsUt31ZAimiMTiQHyaSlfg.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG__3JaQ4WA8mWGoirIZlhfCA.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_TcqCMzjjZ8aFWAW7rqYA7w.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_h95saZexBiRuLoVSs3RQHA.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_E6TrPMp1Ubm-phZJSuhKOQ.png)
2.6、修改删除表
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_i8Yk24_kLOJfSdkSJY9Ofg.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_YtXUeD-aVceRP6WU_ty5-w.png)
![123 123](https://cdn.ancii.com/article/image/v1/sw/wV/kP/PkwwVsGDmjDG9swnOi7SkjVAsMQAarn73E9S3mmSmcD8wuWocuaVrZ0ypSZaHGG_p5GwK710UrE4BhnQQEQvUw.png)