SQL基础

一些重要的SQL命令

• SELECT 从数据库中提取数据
• UPDATE 更新数据库中的数据
• DELETE 删除数据库中的数据
• INSERT INTO 插入数据
• CREATE DATABASE 创建新数据库
• ALTER DATABASE 修改数据库
• CREATE TABLE 新建表
• ALTER TABLE 改变数据库表
• DROP TABLE 删除表
• CREATE INDEX 创建索引
• DROP INDEX 删除索引

SELECT

1. SELECT id,name FROM user;
2. SELECT * FROM user;

SELECT DISTINCT

1. SELECT DISTINCT name FROM user;(用于返回唯一不同的值)

WHERE

SELECT * FROM user WHERE name=‘su’;

AND&OR

1. AND:
   SELECT * FROM Websites
   WHERE country=‘CN’
   AND alexa > 50;

2. OR
   SELECT * FROM Websites
   WHERE country=‘USA’
   OR country=‘CN’;

ORDER BY

1. 降序：DESC
2. 升序：ASC
   SELECT column_name,column_name
   FROM table_name
   ORDER BY column_name,column_name ASC|DESC;

INSERT INTO

1. INSERT INTO table_name VALUES (value1,value2…);
2. INSERT INTO table_name(column1,coulumn2…) VALUES (value1,value2…);

UPDATE

UPDATE user
SET name=‘aa’,age=10
WHERE id=001;

DELETE

DELETE FROM user
WHERE id=123;