mysql基础命令（增删改查）

创建数据库：
CREATE DATABASE database_name;

删除数据库：
DROP DATABASE database_name;

使用数据库：
USE database_name;

显示所有数据库：
SHOW DATABASES;

创建表：
CREATE TABLE table_name (
column1 datatype constraint,
column2 datatype constraint,
...
);

删除表：
DROP TABLE table_name;

插入数据：
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

更新数据：
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

删除数据：
DELETE FROM table_name WHERE condition;

查询数据：
SELECT column1, column2, ... FROM table_name WHERE condition;

查询所有数据：
SELECT * FROM table_name;

查询唯一的数据（去重）：
SELECT DISTINCT column1, column2, ... FROM table_name;

排序数据：
SELECT column1, column2, ... FROM table_name ORDER BY column1 ASC/DESC;

限制查询结果行数：
SELECT column1, column2, ... FROM table_name LIMIT num_rows;

分页查询：
SELECT column1, column2, ... FROM table_name LIMIT offset, num_rows;

连接多个表进行查询：
SELECT column1, column2, ... FROM table1 INNER/LEFT/RIGHT JOIN table2 ON condition;

聚合函数操作：

求和：SELECT SUM(column) FROM table_name;
平均值：SELECT AVG(column) FROM table_name;
最大值：SELECT MAX(column) FROM table_name;
最小值：SELECT MIN(column) FROM table_name;
计数：SELECT COUNT(column) FROM table_name;
分组查询：
SELECT column1, column2, ... FROM table_name GROUP BY column;

条件查询：

等于：SELECT * FROM table_name WHERE column = value;
不等于：SELECT * FROM table_name WHERE column <> value;
大于：SELECT * FROM table_name WHERE column > value;
小于：SELECT * FROM table_name WHERE column < value;
大于等于：SELECT * FROM table_name WHERE column >= value;
小于等于：SELECT * FROM table_name WHERE column <= value;
模糊查询：SELECT * FROM table_name WHERE column LIKE pattern;