mysql数据库命令大全
时间: 2023-09-20 19:08:56 浏览: 50
以下是常用的 MySQL 数据库命令大全:
1. 连接数据库:mysql -u username -p password -h hostname
2. 创建数据库:CREATE DATABASE database_name;
3. 删除数据库:DROP DATABASE database_name;
4. 选择数据库:USE database_name;
5. 显示所有数据库:SHOW DATABASES;
6. 显示所有表:SHOW TABLES;
7. 创建表:CREATE TABLE table_name (column1 datatype, column2 datatype, column3 datatype, …);
8. 删除表:DROP TABLE table_name;
9. 插入数据:INSERT INTO table_name (column1, column2, column3, …) VALUES (value1, value2, value3, …);
10. 更新数据:UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition;
11. 删除数据:DELETE FROM table_name WHERE condition;
12. 查询数据:SELECT column1, column2, … FROM table_name WHERE condition;
13. 查询数据并排序:SELECT column1, column2, … FROM table_name ORDER BY column_name ASC|DESC;
14. 查询数据并分组:SELECT column1, column2, … FROM table_name GROUP BY column_name;
15. 查询数据并计数:SELECT COUNT(*) FROM table_name;
16. 查询数据并求和:SELECT SUM(column_name) FROM table_name;
17. 查询数据并求平均值:SELECT AVG(column_name) FROM table_name;
18. 查询数据并求最大值:SELECT MAX(column_name) FROM table_name;
19. 查询数据并求最小值:SELECT MIN(column_name) FROM table_name;
20. 退出 MySQL:quit;
相关推荐
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)