![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
文章平均质量分 79
weixin_47485680
这个作者很懒,什么都没留下…
展开
-
DDL, DML, DCL, DQL, DTL
Generally SQL is classified into three types: DDL, DML, DCL.Some times we can also hear DQL, DTL(TCL). Let's look at the differences.Data Definition Language (DDL)refers to the CREATE, ALTER and DROP statements.DDL or Data Definition Language actua.原创 2022-02-26 23:23:10 · 101 阅读 · 0 评论 -
DELETE vs TRUNCATE
DDL(Data Definition Language, like create, drop, alter, truncate, add, modify, change, rename...) is commited when executed anyway.DML(Data Manipulation Language, like insert, delete, add, update, select...) is commited when executed by default. If autoc原创 2022-02-26 23:13:50 · 208 阅读 · 0 评论 -
SQL查询基本原理(过程)
SQL查询是我们用得最多的语句,掌握其工作原理可以帮助我们理解SQL语法结构。基本上有6大步骤:1. 获取数据 - FROM, JOIN2. 行过滤 - WHERE3. 分组 -GROUP BY4. 分组过滤 - HA...原创 2022-02-19 08:46:35 · 757 阅读 · 0 评论 -
How a SQL SELECT statement works
In this topic, I'll talk about the procedure of execution for a SQL SELECT statement.Basically there're 6 steps for a query:1. GetData - FROM, JOIN2. Filter Row - WHERE3. Group ...原创 2022-02-19 02:38:33 · 315 阅读 · 0 评论 -
WHERE, HAVING, GROUP BY in SQL
WHERE, HAVING, GROUP BY summary原创 2022-02-18 04:43:07 · 180 阅读 · 0 评论