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;