SQL基础知识（二）

三、基本语法

今天记录 SQL Select, Distinct, Where, And & Or, Order by, Insert Into, Update, Delete, Injection, Select Top 这十个关键字或者命令的用法和解释。

1、Select

The SELECT statement is used to select data from a database.

The result is stored in a result table, called the result-set.

SQL SELECT Syntax

SELECT column_name, column_name
FROM table_name;

and

SELECT * FROM table_name;

2、Distinct

The SELECT DISTINCT statement is used to return only distinct (different) values.

SQL SELECT DISTINCT Syntax

SELECT DISTINCT column_name, column_name
FROM table_name;

3、Where

The WHERE clause is used to filter records.

SQL WHERE Syntax

SELECT column_name, column_name
FROM table_name
WHERE column_name operator value;

Example

SELECT * FROM Customers
WHERE Country='Mexico';

SELECT * FROM Customers
WHERE CustomerID=1;