MySQL常用语句

 

MySQL 是一个流行的开源关系型数据库管理系统，常用语句包括：

1. 创建数据库:

CREATE DATABASE database_name;

2.删除数据库:

DROP DATABASE database_name;

 3.创建表:

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    ...
);

4.删除表:

DROP TABLE table_name;

5.插入数据:

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

6.查询数据:

SELECT column1, column2, ... FROM table_name WHERE condition;

7.更新数据:

UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

 8.删除数据:

DELETE FROM table_name WHERE condition;

9.查询表结构:

DESC table_name;

10.连接表:

SELECT * FROM table1 JOIN table2 ON table1.column_name = table2.column_name;

11.简单查询排序：

SELECT * FROM table_name ORDER BY column_name ASC|DESC;

12.聚合函数：

SELECT COUNT(column_name) FROM table_name;
SELECT AVG(column_name) FROM table_name;
SELECT SUM(column_name) FROM table_name;
SELECT MAX(column_name) FROM table_name;
SELECT MIN(column_name) FROM table_name;

13.使用 WHERE 子句和逻辑运算符进行复杂查询：

SELECT * FROM table_name WHERE condition1 AND condition2;
SELECT * FROM table_name WHERE condition1 OR condition2;

14.使用通配符进行模糊查询：

SELECT * FROM table_name WHERE column_name LIKE 'pattern';

15.创建索引：

CREATE INDEX index_name ON table_name (column_name);

16.删除索引：

DROP INDEX index_name ON table_name;

17.修改表结构：

ALTER TABLE table_name ADD column_name datatype;
ALTER TABLE table_name MODIFY column_name datatype;
ALTER TABLE table_name DROP column_name;