三、基本语法
今天记录 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;