sql語句大全

1、創建表：

Copy code

CREATE TABLE table_name (

  column1 datatype,

  column2 datatype,

  column3 datatype,

  ...

);

2、插入數據：

Copy code

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

VALUES (value1, value2, value3, ...);

更新數據：

Copy code

UPDATE table_name

SET column1 = value1, column2 = value2, ...

WHERE condition;

3、刪除數據：

Copy code

DELETE FROM table_name

WHERE condition;

4、查詢數據：

Copy code

SELECT column1, column2, ...

FROM table_name

WHERE condition;

5、按條件排序：

Copy code

SELECT column1, column2, ...

FROM table_name

WHERE condition

ORDER BY column1 ASC/DESC;

6、使用聚合函數計算數據：

Copy code

SELECT COUNT(column_name) FROM table_name;

SELECT SUM(column_name) FROM table_name;

SELECT AVG(column_name) FROM table_name;

SELECT MAX(column_name) FROM table_name;

SELECT MIN(column_name) FROM table_name;