SQL常用命令

======
选择

SELECT * FROM table_name;

SELECT column_name,column_name
FROM table_name;


column_name为需要显示的列

例子:
SELECT name,country FROM Websites;


=====
忽略相同的值

SELECT DISTINCT column_name,column_name
FROM table_name;

column为需要的输出。如果里面有一样的值则只输出其中一个

例子:
SELECT DISTINCT country FROM Websites;


=====
过滤

SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;

例子:
SELECT * FROM Websites WHERE country='CN';


=====
运算符

例子:
SELECT * FROM Websites
WHERE country='CN'
AND alexa > 50;

SELECT * FROM Websites
WHERE country='USA'
OR country='CN';


SELECT * FROM Websites
WHERE alexa > 15
AND (country='CN' OR country='USA');



====
排序

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

descend  降
ascend   升

默认升序
例子:
SELECT * FROM Websites
ORDER BY alexa;

=====
插入

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

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


例子:
INSERT INTO Websites (name, url, alexa, country)
VALUES ('百度',' https://www.baidu.com/','4','CN');

=====
更新

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

例子:
UPDATE Websites
SET alexa='5000', country='USA'
WHERE name='菜鸟教程';

======
删除

DELETE FROM table_name
WHERE some_column=some_value;

例子:


DELETE FROM Websites
WHERE name='百度' AND country='CN';
======