SQL_菜鸟教程_select

---

基础关键字使用

select

SELECT column_name,column_name FROM table_name;

SELECT * FROM table_name;
## distinct 关键字表示返回唯一不同值
SELECT DISTINCT column_name,column_nameFROM table_name;

where

where 用于筛选过滤

SELECT column_name,column_name FROM table_name WHERE column_name operator value;

and & or

用于过滤，and取交集，or取并集

SELECT * FROM Websites WHERE country='CN' AND alexa > 50;
#and和or 同时使用
SELECT * FROM Websites WHERE alexa > 15 AND (country='CN' OR country='USA');

order by

用于排序
ASC:

SELECT column_name,column_name FROM table_name ORDER BY column_name,column_name ASC|DESC;

order by A ,B desc

注意：
排序优先级，先按照第一个列名排序
默认排序按照升序排列 ASC ，可以不写
order by 多列，可以不同列不同排序方式

insert into

INSERT INTO table_name VALUES (value1,value2,value3,...);

INSERT INTO table_name (column1,column2,column3,...