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;