mysql数据库命令大全
时间: 2023-09-21 20:03:35 浏览: 36
以下是 MySQL 数据库命令大全:
1. 连接数据库:mysql -u [用户名] -p [密码]
2. 显示当前数据库:SELECT DATABASE();
3. 显示所有数据库:SHOW DATABASES;
4. 创建数据库:CREATE DATABASE [数据库名];
5. 删除数据库:DROP DATABASE [数据库名];
6. 使用数据库:USE [数据库名];
7. 显示所有表格:SHOW TABLES;
8. 创建表格:CREATE TABLE [表格名] ([列名] [数据类型] [其他属性]);
9. 删除表格:DROP TABLE [表格名];
10. 插入数据:INSERT INTO [表格名] ([列名], [列名], ...) VALUES ([值], [值], ...);
11. 更新数据:UPDATE [表格名] SET [列名] = [新值] WHERE [条件];
12. 删除数据:DELETE FROM [表格名] WHERE [条件];
13. 查询数据:SELECT [列名] FROM [表格名] WHERE [条件];
14. 排序数据:SELECT [列名] FROM [表格名] ORDER BY [列名] [ASC/DESC];
15. 分组数据:SELECT [列名] FROM [表格名] GROUP BY [列名];
16. 连接表格:SELECT [列名] FROM [表格名1] JOIN [表格名2] ON [条件];
17. 子查询:SELECT [列名] FROM [表格名] WHERE [列名] IN (SELECT [列名] FROM [表格名] WHERE [条件]);
18. 聚合函数:SELECT COUNT([列名]), MAX([列名]), MIN([列名]), AVG([列名]), SUM([列名]) FROM [表格名];
19. 创建索引:CREATE INDEX [索引名] ON [表格名] ([列名]);
20. 删除索引:DROP INDEX [索引名] ON [表格名];
以上是常用的 MySQL 数据库命令,希望可以帮助到你。