SQL 语句快速参考

文宇肃然

于 2015-01-20 12:22:49 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库应用实战案例集锦

本文链接：https://blog.youkuaiyun.com/wenyusuran/article/details/42916229

本文是SQL语句的快速参考，涵盖了从基本的SELECT语句到JOIN操作，子查询，聚合函数以及WHERE和HAVING子句等核心概念，旨在帮助读者迅速查找和理解SQL查询的关键元素。

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

语句	语法
AND / OR	SELECT column_name(s) FROM table_name WHERE condition AND\|OR condition
ALTER TABLE (add column)	ALTER TABLE table_name ADD column_name datatype
ALTER TABLE (drop column)	ALTER TABLE table_name DROP COLUMN column_name
AS (alias for column)	SELECT column_name AS column_alias FROM table_name
AS (alias for table)	SELECT column_name FROM table_name AS table_alias
BETWEEN	SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2
CREATE DATABASE	CREATE DATABASE database_name