这篇博客总结了SQL语言的主要语法，包括SELECT、DISTINCT、WHERE、ORDER BY、INSERT INTO、NULL值处理、UPDATE、DELETE、聚合函数、LIKE操作符、JOIN类型、UNION、GROUP BY、HAVING、EXISTS、ANY和ALL操作符以及CASE语句等内容。
SQL SYNTAX
Reference:本文大部分是对w3c网站的教程的总结
- SQL SELECT
select Column
select *
- SQL SELECT DISTINCT
select distinct
select COUNT(distinct column_name)
- SQL WHERE
where clause
- SQL AND,OR AND NOT Operators
SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;
SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;
SELECT column1, column2, ...
FROM table_name
WHERE NOT condition;
- SQL ORDER BY
ASC:ascending/
DESC:descending
order by
order by desc
order by several column
SELECT * FROM Customers
ORDER BY Country ASC, CustomerName DESC;
- SQL INSERT INTO
INSERT INTO
If you are adding values for all the columns of the table, you do not need to specify the column names in the SQL query.
INSERT INTO table_name
VALUES (value1, value2, value3, ...)
Insert Data Only in Specified Columns
The following SQL statement will insert a new record, but only insert data in the “CustomerName”, “City”, and “Country” columns (CustomerID will be updated automatically):
INSERT INTO Customers (CustomerName, City, Country)
VALUES ('Cardinal', 'Stavanger', 'Norway');
- SQL NULL Values
We will have to use the IS NULL and IS NOT NULL operators instead.
S
最低0.47元/天 解锁文章
549
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
