【10 天学会10门技术极简教程系列】SQL 编程语言极简教程

AI天才研究院

已于 2024-09-24 00:29:31 修改

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

分类专栏：编程实践一天一门编程语言文章标签： sql 数据库

于 2023-09-27 12:16:52 首次发布

本文链接：https://blog.youkuaiyun.com/universsky2015/article/details/133268990

编程实践同时被 2 个专栏收录

309 篇文章 ¥39.90 ¥99.00

订阅专栏

超级会员免费看

一天一门编程语言

117 篇文章 ¥39.90 ¥99.00

订阅专栏

超级会员免费看

这篇教程涵盖了SQL编程语言的基础，包括DDL（数据定义语言）、DCL（数据控制语言）、DML（数据操纵语言）和DQL（数据查询语言）。内容涉及数据类型、操作符、约束、视图、事务以及各种类型的JOIN操作。此外，还介绍了子查询、条件选择、聚合函数以及如何进行数据分组和过滤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL 编程语言极简教程

文章目录

SQL 编程语言极简教程
SQL languages
Datatypes
DDL & DCL
DML & DQL
- - - Insert
    - Delete
    - - Example:
        
        Example:
    - Update
    - - Example:
    - Set
    - - Example:
    - Select
    - - Example 1:
        
        Example 2:
    - Conditional select
    - Distinct
    - - Example:
    - Limit
    - - Example:
    - Order
    - Like
    - - Example 1:
        
        Example 2:
        
        Example 3:
    - Not
    - - Example:
    - Case
    - - Example:
    - And
    - Or
    - - Example:
    - As
    - Between
    - - Example 1:
        
        Example 2:
        
        Consider tables
    - Union
    - - Example:
    - Intersect
    - - Example:
    - Except
    - - Example:
        
        Consider tables:
    - Common Functions
Sub Queries
- - Single value
- - Multiple value
- - - In
    - Any
    - All
- - Correlated
- - - Exists
    - - Example:
    - Group By
    - - Example:
    - Having
    - - Example:
    - With
    - - Example 1:
Join
Transactions
Relational division

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such INSERT, UPDATE, DELETE etc, and it is used to store, modify, delete and update data in database.

DQL is short name of Data Query Language which u