SQL教程——索引

朱雀 2022-12-25 02:56 113阅读 0赞

> **导语：笔者用mysql做了一年多简单的开发后，为了夯实自己的数据库基础，对数据库的基础SQL部分进行了二次学习，期间记下了很多笔记，本教程即是以这些笔记为大纲，内容详尽，理论和实战相结合，建议初学者照着索引中文章的顺序走一遍，阅读文中基础知识，并亲手敲一遍文中的实例代码，走完整个教程之后，一定会为自己的数据库基础打下牢固的基础！**

**本篇文章为整个教程的索引部分，可以在这里看到所有文章的层次关系，或者下载文章中使用的数据库SQL文件。**

**目录**

[一、查询语言DQL][DQL]

[1.select语法][DQL]

[2.where语法][2.where]

[3.order by语法][3.order by]

[4.group by语法][4.group by]

[5.常见函数][5.]

[1.单行函数][5.]

[2.分组函数][2.]

[6.连接查询][6.]

[1.SQL92标准][6.]

[2.SQL99标准][2.SQL99]

[7.子查询][7.]

[8.分页查询][8.]

[9.联合查询][9.]

[二、DML语言][DML]

[1.增][DML]

[2.删][2. 1]

[3.改][3.]

[三、DDL语言][DDL]

[1.库的管理][DDL]

[2.表的管理][2. 2]

[3.常见的数据类型][3. 1]

[4.常见的约束类型][4.]

[四、TCL语言][TCL]

[五、视图][Link 1]

[六、变量][Link 2]

[七、存储过程和函数][Link 3]

[1.存储过程][Link 3]

[2.函数][2. 3]

[八、流程控制结构][Link 4]

[1.分支结构][Link 4]

[2.循环结构][2. 4]

--------------------

**本教程中共使用到了两个数据库，myemployees数据库和girls数据库，两个SQL文件都放在了我的服务器上，点击即可直接下载：**

**[girls.sql][]**

**[myemployees.sql][]**

[DQL]: https://blog.csdn.net/IT_TIfarmer/article/details/110382623
[2.where]: https://blog.csdn.net/IT_TIfarmer/article/details/110385548
[3.order by]: https://blog.csdn.net/IT_TIfarmer/article/details/110387338
[4.group by]: https://blog.csdn.net/IT_TIfarmer/article/details/110387450
[5.]: https://blog.csdn.net/IT_TIfarmer/article/details/110387699
[2.]: https://blog.csdn.net/IT_TIfarmer/article/details/110388678
[6.]: https://blog.csdn.net/IT_TIfarmer/article/details/110388845
[2.SQL99]: https://blog.csdn.net/IT_TIfarmer/article/details/110389023
[7.]: https://blog.csdn.net/IT_TIfarmer/article/details/110389287
[8.]: https://blog.csdn.net/IT_TIfarmer/article/details/110413164
[9.]: https://blog.csdn.net/IT_TIfarmer/article/details/110413289
[DML]: https://blog.csdn.net/IT_TIfarmer/article/details/110413351
[2. 1]: https://blog.csdn.net/IT_TIfarmer/article/details/110413427
[3.]: https://blog.csdn.net/IT_TIfarmer/article/details/110413490
[DDL]: https://blog.csdn.net/IT_TIfarmer/article/details/110413557
[2. 2]: https://blog.csdn.net/IT_TIfarmer/article/details/110413603
[3. 1]: https://blog.csdn.net/IT_TIfarmer/article/details/110413640
[4.]: https://blog.csdn.net/IT_TIfarmer/article/details/110413739
[TCL]: https://blog.csdn.net/IT_TIfarmer/article/details/110423569
[Link 1]: https://blog.csdn.net/IT_TIfarmer/article/details/110459411
[Link 2]: https://blog.csdn.net/IT_TIfarmer/article/details/110459568
[Link 3]: https://blog.csdn.net/IT_TIfarmer/article/details/110459712
[2. 3]: https://blog.csdn.net/IT_TIfarmer/article/details/110459940
[Link 4]: https://blog.csdn.net/IT_TIfarmer/article/details/110460016
[2. 4]: https://blog.csdn.net/IT_TIfarmer/article/details/110460130
[girls.sql]: https://xiaohang456.top/SRepair/girls.sql
[myemployees.sql]: https://xiaohang456.top/SRepair/myemployees.sql