MySQL数据库基础教程（视频）

亦凉 2022-06-11 04:26 216阅读 0赞

本教程涵盖所有MySQL数据库,学习基本知识和数据表的主要用途用于操作MySQL数据库和各种约束条件,并综合使用各种命令记录进行CURD等操作,本课程的目的是“看得懂、学得会、做得出”,并为后续的学习打下坚实的基础。

1.  [MySQL数据库概述][MySQL]
2.  [MySQL数据库的安装与配置][MySQL 1]
3.  [MySQL数据库-启动与停止MySQL服务][MySQL_-_MySQL]
4.  [MySQL数据库登录与退出][MySQL 2]
5.  [修改MySQL提示符][MySQL 3]
6.  [MySQL数据库常用命令以及语法规范][MySQL 4]
7.  [如何操作MySQL数据库][MySQL 5]
8.  [MySQL数据库数据类型之整型][MySQL 6]
9.  [MySQL数据库数据类型之浮点型][MySQL 7]
10. [MySQL数据库数据类型-日期时间型][MySQL_-]
11. [MySQL数据库数据类型中的字符型][MySQL 8]
12. [MySQL数据库创建数据表][MySQL 9]
13. [MySQL数据库查看数据表][MySQL 10]
14. [MySQL数据库查看数据表结构][MySQL 11]
15. [MySQL数据库记录的插入与查找][MySQL 12]
16. [MySQL数据库空值与非空][MySQL 13]
17. [MySQL数据库自动编号][MySQL 14]
18. [MySQL数据库简述主键(PRIMARY KEY)约束][MySQL_PRIMARY KEY]
19. [MySQL数据库简述唯一约束(UNIQUE KEY）][MySQL_UNIQUE KEY]
20. [MySQL数据库简述默认约束][MySQL 15]
21. [MySQL数据类型与操作数据表小结][MySQL 16]
22. [MySQL数据库已经学习教程的回顾和概述][MySQL 17]
23. [MySQL数据库外键约束的要求解析][MySQL 18]
24. [MySQL数据库外键约束的参照操作][MySQL 19]
25. [MySQL数据库表级约束与列级约束][MySQL 20]
26. [MySQL数据库修改数据表-添加-删除列][MySQL_-_-]
27. [MySQL数据库修改数据表--添加约束][MySQL_--]
28. [MySQL数据库修改数据表--删除约束][MySQL_-- 1]
29. [MySQL修改数据表--修改列定义和更名数据表][MySQL_-- 2]
30. [MySQL数据库约束和修改数据表小结][MySQL 21]
31. [MySQL数据库以前教程回顾和概述][MySQL 22]
32. [MySQL数据库插入记录INSERT][MySQL_INSERT]
33. [MySQL数据库插入记录INSERTSET-SELECT][MySQL_INSERTSET-SELECT]
34. [MySQL数据库单表更新记录UPDATE][MySQL_UPDATE]
35. [MySQL数据库单表删除记录DELETE][MySQL_DELETE]
36. [MySQL数据库查询表达式解析][MySQL 23]
37. [MySQL数据库where语句进行条件查询][MySQL_where]
38. [MySQL数据库groupby语句对查询结果分组][MySQL_groupby]
39. [MySQL数据库having语句设置分组条件][MySQL_having]
40. [MySQL数据库-orderby语句对查询结果排序][MySQL_-orderby]
41. [MySQL数据库-limit语句限制查询数量][MySQL_-limit]
42. [MySQL数据库-操作数据表中的记录小结(增删改查)][MySQL_- 1]  
    
43. [MySQL数据库-为展示子查询与连接进行数据准备][MySQL_- 2]
44. [MySQL数据库-子查询概述][MySQL_- 3]
45. [MySQL数据库-由比较运算符引发的子查询][MySQL_- 4]
46. [MySQL数据库-由\[NOT\]IN-EXISTS引发的子查询][MySQL_-_NOT_IN-EXISTS]
47. [MySQL数据库-使用INSERT...SELECT插入记录][MySQL_-_INSERT...SELECT]
48. [MySQL数据库-多表更新][MySQL_- 5]
49. [MySQL数据库-多表更新之一步到位][MySQL_- 6]
50. [MySQL数据库-连接(JOIN)的语法结构][MySQL_-_JOIN]
51. [MySQL数据库-内连接INNERJOIN][MySQL_-_INNERJOIN]
52. [MySQL数据库-外连接OUTERJOIN][MySQL_-_OUTERJOIN]
53. [MySQL数据库-多表连接][MySQL_- 7]
54. [MySQL数据库-关于连接的几点说明][MySQL_- 8]
55. [MySQL数据库-无限级分类表设计][MySQL_- 9]
56. [MySQL数据库-多表删除(DELETE)][MySQL_-_DELETE]
57. [MySQL数据库-字符函数][MySQL_- 10]
58. [MySQL数据库-数值运算符和函数][MySQL_- 11]
59. [MySQL数据库-比较运算符和函数][MySQL_- 12]
60. [MySQL数据库-日期时间函数][MySQL_- 13]
61. [MySQL数据库-信息函数][MySQL_- 14]
62. [MySQL数据库-聚合函数][MySQL_- 15]
63. [MySQL数据库-加密函数][MySQL_- 16]
64. [MySQL数据库-自定义函数概述][MySQL_- 17]
65. [MySQL数据库-创建不带参数的自定义函数][MySQL_- 18]
66. [MySQL数据库-创建带有参数的自定义函数][MySQL_- 19]
67. [MySQL数据库-创建具有复合结构函数体的自定义函数][MySQL_- 20]
68. [MySQL数据库-存储过程概述][MySQL_- 21]
69. [MySQL数据库-存储过程语法结构解析][MySQL_- 22]
70. [MySQL数据库-创建不带参数的存储过程][MySQL_- 23]
71. [MySQL数据库-创建带有IN类型参数的存储过程][MySQL_-_IN]  
    
72. [MySQL数据库-创建带有IN和OUT类型参数的存储过程][MySQL_-_IN_OUT]  
    
73. [MySQL数据库-创建带有多个OUT类型参数的存储过程][MySQL_-_OUT]
74. [MySQL数据库-存储过程与自定义函数的区别][MySQL_- 24]
75. [MySQL数据库-存储引擎概述][MySQL_- 25]
76. [MySQL数据库-并发处理相关知识点][MySQL_- 26]
77. [MySQL数据库-事务处理相关知识点][MySQL_- 27]  
    
78. [MySQL数据库-外键和索引相关知识点][MySQL_- 28]
79. [MySQL数据库-各种存储引擎特点][MySQL_- 29]
80. [MySQL数据库-设置存储引擎][MySQL_- 30]
81. [MySQL数据库-图形化管理工具概述][MySQL_- 31]
82. [MySQL数据库-图形管理工具(phpMyAdmin)][MySQL_-_phpMyAdmin]
83. [MySQL数据库-图形管理工具(NavicatforMySQL)][MySQL_-_NavicatforMySQL]
84. [MySQL数据库-图形管理工具(MySQLWorkbench)][MySQL_-_MySQLWorkbench]

[MySQL]: http://v.youku.com/v_show/id_XMjg4NjA1NTMzNg==.html
[MySQL 1]: http://v.youku.com/v_show/id_XMjg4NjA3ODczNg==.html
[MySQL_-_MySQL]: http://v.youku.com/v_show/id_XMjg4NjExMTA1Ng==.html
[MySQL 2]: http://v.youku.com/v_show/id_XMjg4NjE2NDg0OA==.html
[MySQL 3]: http://v.youku.com/v_show/id_XMjg4NjIzMTUwOA==.html
[MySQL 4]: http://v.youku.com/v_show/id_XMjg4NjI0NTgzMg==.html
[MySQL 5]: http://v.youku.com/v_show/id_XMjg4NjE5OTc0NA==.html
[MySQL 6]: http://v.youku.com/v_show/id_XMjg4NjI2Mjc0MA==.html
[MySQL 7]: http://v.youku.com/v_show/id_XMjg4NjI1MTY5Ng==.html
[MySQL_-]: http://v.youku.com/v_show/id_XMjg4ODE2MjYzNg==.html
[MySQL 8]: http://v.youku.com/v_show/id_XMjg4ODE3ODc0MA==.html
[MySQL 9]: http://v.youku.com/v_show/id_XMjg4ODE5NjU0MA==.html
[MySQL 10]: http://v.youku.com/v_show/id_XMjg4ODIwNTY3Mg==.html
[MySQL 11]: http://v.youku.com/v_show/id_XMjg4ODIxMzA4MA==.html
[MySQL 12]: http://v.youku.com/v_show/id_XMjg4ODI0OTY2NA==.html
[MySQL 13]: http://v.youku.com/v_show/id_XMjg4ODI1OTMyOA==.html
[MySQL 14]: http://v.youku.com/v_show/id_XMjg4ODI3NjE2NA==.html
[MySQL_PRIMARY KEY]: http://v.youku.com/v_show/id_XMjg4ODI5NzcwNA==.html
[MySQL_UNIQUE KEY]: http://v.youku.com/v_show/id_XMjg4ODMyMDIwOA==.html
[MySQL 15]: http://v.youku.com/v_show/id_XMjg5MDE0MDQwMA==.html
[MySQL 16]: http://v.youku.com/v_show/id_XMjg5MDE0ODg4NA==.html
[MySQL 17]: http://v.youku.com/v_show/id_XMjg5MDE4NTM3Ng==.html
[MySQL 18]: http://v.youku.com/v_show/id_XMjg5MDIxNjM4OA==.html
[MySQL 19]: http://v.youku.com/v_show/id_XMjg5MDIzNTMwMA==.html
[MySQL 20]: http://v.youku.com/v_show/id_XMjg5MDI1MjExNg==.html
[MySQL_-_-]: https://mparticle.uc.cn/video.html?uc_param_str=frdnsnpfvecpntnwprdssskt&wm_id=02a9f2d5552a45c1bdc6abe376beefaf&wm_aid=http://v.youku.com/v_show/id_XMjg5MDI3MDE4NA==.html
[MySQL_--]: http://v.youku.com/v_show/id_XMjg5MDI5MDIyMA==.html
[MySQL_-- 1]: http://v.youku.com/v_show/id_XMjg5MDMxMDY0OA==.html
[MySQL_-- 2]: http://v.youku.com/v_show/id_XMjg5MDM0MzE3Mg==.html
[MySQL 21]: http://v.youku.com/v_show/id_XMjg5MzAyMDc5Ng==.html
[MySQL 22]: http://v.youku.com/v_show/id_XMjg5MzA0OTcxNg==.html
[MySQL_INSERT]: http://v.youku.com/v_show/id_XMjg5MzA5NDc2NA==.html
[MySQL_INSERTSET-SELECT]: http://v.youku.com/v_show/id_XMjg5MzE3OTQ2MA==.html
[MySQL_UPDATE]: http://v.youku.com/v_show/id_XMjg5MzE5MTAyNA==.html
[MySQL_DELETE]: http://v.youku.com/v_show/id_XMjg5MzIxNDEyMA==.html
[MySQL 23]: http://v.youku.com/v_show/id_XMjg5MzIzODY5Mg==.html
[MySQL_where]: http://v.youku.com/v_show/id_XMjg5MzI1OTczNg==.html
[MySQL_groupby]: http://v.youku.com/v_show/id_XMjg5MzI2MjQ5Mg==.html
[MySQL_having]: http://v.youku.com/v_show/id_XMjg5MzI4NDE5Ng==.html
[MySQL_-orderby]: http://v.youku.com/v_show/id_XMjg5NTE3MDQ2MA==.html
[MySQL_-limit]: http://v.youku.com/v_show/id_XMjg5NTE3ODE0OA==.html
[MySQL_- 1]: http://v.youku.com/v_show/id_XMjg5NTE4OTIwMA==.html
[MySQL_- 2]: http://v.youku.com/v_show/id_XMjg5NTE5ODY4NA==.html
[MySQL_- 3]: http://v.youku.com/v_show/id_XMjg5NTIyNDQ3Mg==.html
[MySQL_- 4]: http://v.youku.com/v_show/id_XMjg5NTIzMjQ1Ng==.html
[MySQL_-_NOT_IN-EXISTS]: http://v.youku.com/v_show/id_XMjg5NTI1MTY4OA==.html
[MySQL_-_INSERT...SELECT]: http://v.youku.com/v_show/id_XMjg5NTI1ODY0MA==.html
[MySQL_- 5]: http://v.youku.com/v_show/id_XMjg5NTI3MDY0NA==.html
[MySQL_- 6]: http://v.youku.com/v_show/id_XMjg5NTI3OTYxMg==.html
[MySQL_-_JOIN]: http://v.youku.com/v_show/id_XMjg5NzI3MzAxMg==.html
[MySQL_-_INNERJOIN]: http://v.youku.com/v_show/id_XMjg5NzI5NzA0MA==.html
[MySQL_-_OUTERJOIN]: http://v.youku.com/v_show/id_XMjg5NzI5MzkwOA==.html
[MySQL_- 7]: http://v.youku.com/v_show/id_XMjg5NzMwMTk4MA==.html
[MySQL_- 8]: http://v.youku.com/v_show/id_XMjg5NzY4MTMxMg==.html
[MySQL_- 9]: http://v.youku.com/v_show/id_XMjg5NzY5NDUwOA==.html
[MySQL_-_DELETE]: http://v.youku.com/v_show/id_XMjg5NzcwNDQzNg==.html
[MySQL_- 10]: http://v.youku.com/v_show/id_XMjg5NzczOTI2MA==.html
[MySQL_- 11]: http://v.youku.com/v_show/id_XMjg5Nzc2MzMxMg==.html
[MySQL_- 12]: http://v.youku.com/v_show/id_XMjg5Nzc4ODc0NA==.html
[MySQL_- 13]: http://v.youku.com/v_show/id_XMjg5OTMwMzY2NA==.html
[MySQL_- 14]: http://v.youku.com/v_show/id_XMjg5OTM0NTcyNA==.html
[MySQL_- 15]: http://v.youku.com/v_show/id_XMjg5OTM5NTU2MA==.html
[MySQL_- 16]: http://v.youku.com/v_show/id_XMjg5OTQzNDkxNg==.html
[MySQL_- 17]: http://v.youku.com/v_show/id_XMjg5OTQzNzI0OA==.html
[MySQL_- 18]: http://v.youku.com/v_show/id_XMjg5OTQ4NTM4NA==.html
[MySQL_- 19]: http://v.youku.com/v_show/id_XMjg5OTUwMjU4MA==.html
[MySQL_- 20]: http://v.youku.com/v_show/id_XMjg5OTUxMjc4MA==.html
[MySQL_- 21]: http://v.youku.com/v_show/id_XMjg5OTUyMjU4NA==.html
[MySQL_- 22]: http://v.youku.com/v_show/id_XMjg5OTU2MTkzMg==.html
[MySQL_- 23]: http://v.youku.com/v_show/id_XMjkwMTU1ODQzNg==.html
[MySQL_-_IN]: http://v.youku.com/v_show/id_XMjkwMTU4Mjc4OA==.html
[MySQL_-_IN_OUT]: http://v.youku.com/v_show/id_XMjkwMTYwMTE0OA==.html
[MySQL_-_OUT]: http://v.youku.com/v_show/id_XMjkwMTYzODQyOA==.html
[MySQL_- 24]: http://v.youku.com/v_show/id_XMjkwMTY4NjE0MA==.html
[MySQL_- 25]: http://v.youku.com/v_show/id_XMjkwMTczNTU1Mg==.html
[MySQL_- 26]: http://v.youku.com/v_show/id_XMjkwMTczNzc4MA==.html
[MySQL_- 27]: http://v.youku.com/v_show/id_XMjkwMTc4ODcwNA==.html
[MySQL_- 28]: http://v.youku.com/v_show/id_XMjkwMTgxMDEwMA==.html
[MySQL_- 29]: http://v.youku.com/v_show/id_XMjkwMTgzOTIyOA==.html
[MySQL_- 30]: http://v.youku.com/v_show/id_XMjkwNDU4ODM3Mg==.html
[MySQL_- 31]: http://v.youku.com/v_show/id_XMjkwNDYxMjkzMg==.html
[MySQL_-_phpMyAdmin]: http://v.youku.com/v_show/id_XMjkwNDYyNTc4MA==.html
[MySQL_-_NavicatforMySQL]: http://v.youku.com/v_show/id_XMjkwNDY1NDY2MA==.html
[MySQL_-_MySQLWorkbench]: http://v.youku.com/v_show/id_XMjkwNDY0OTEwOA==.html