SQL增删改查语句格式

SQL（Structured Query Language）中的增删改查（CRUD）操作是最基本的数据操作指令。以下是一个简要介绍，包括每个操作的语句格式：

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

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

例如：

INSERT INTO students (student_id, name, age)

VALUES (1001, '张三', 18);

DELETE FROM table_name

WHERE condition;

例如：

DELETE FROM students

WHERE student_id = 1001;

UPDATE table_name

SET column1 = new_value1, column2 = new_value2, ...

WHERE condition;

例如：

UPDATE students

SET age = 20

WHERE student_id = 1001;

SELECT column1, column2, ...

FROM table_name

[WHERE condition]

[ORDER BY column [ASC | DESC]]

[LIMIT limit_count];

例如：

SELECT * FROM students

WHERE age > 18

ORDER BY student_id ASC;