数据库 语句大全

以下是常用的数据库语句：

1. 创建表：

CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, ..... );

2. 删除表：

DROP TABLE table_name;

3. 插入数据：

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

4. 更新数据：

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

5. 删除数据：

DELETE FROM table_name WHERE some_column = some_value;

6. 查询数据：

SELECT column1, column2, ... FROM table_name WHERE some_column = some_value;

7. 排序：

SELECT column1, column2, ... FROM table_name ORDER BY column1 ASC, column2 DESC;

8. 分组：

SELECT column1, COUNT(column2) FROM table_name GROUP BY column1;

9. 连接：

SELECT table1.column1, table2.column2 FROM table1 INNER JOIN table2 ON table1.column1 = table2.column1;

10. 子查询：

SELECT column1 FROM table1 WHERE column2 IN (SELECT column1 FROM table2);

11. 聚合函数：

SELECT COUNT(column1), SUM(column2), AVG(column3) FROM table_name;

12. 嵌套函数：

SELECT COUNT(DISTINCT column1), SUM(DISTINCT column2), AVG(DISTINCT column3) FROM table_name;

13. 联合查询：

SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

14. 交集查询：

SELECT column1 FROM table1 INTERSECT SELECT column1 FROM table2;

15. 差集查询：

SELECT column1 FROM table1 EXCEPT SELECT column1 FROM table2;

16. 存储过程：

CREATE PROCEDURE procedure_name AS BEGIN -- statements END;

17. 触发器：

CREATE TRIGGER trigger_name ON table_name FOR INSERT, UPDATE, DELETE AS BEGIN -- statements END;

18. 索引：

CREATE INDEX index_name ON table_name (column1, column2, ...);

19. 视图：

CREATE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE some_column = some_value;

20. 事务：

BEGIN TRANSACTION; -- statements COMMIT TRANSACTION