2
mysql中对于数据库的基本操作
source link: https://blog.51cto.com/u_12386780/5473878
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
mysql中对于数据库的基本操作
原创1、查看数据库
show databases;
该命令可以查看当前数据库服务中，有几个数据库，如下：
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
6 rows in set (0.00 sec)
mysql>
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
6 rows in set (0.00 sec)
mysql>
2、创建数据库
create database db_name;
该命令可以创建一个数据库，如下：
mysql> create database yunweijia;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
| yunweijia |
+--------------------+
7 rows in set (0.00 sec)
mysql>
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
| yunweijia |
+--------------------+
7 rows in set (0.00 sec)
mysql>
有人问了，如何查看这个数据库创建的状态和过程呢呢，使用如下命令即可了；
show create database db_name
mysql> show create database yunweijia;
+-----------+-------------------------------------------------------------------------------------------------------------------------------------+
| Database | Create Database |
+-----------+-------------------------------------------------------------------------------------------------------------------------------------+
| yunweijia | CREATE DATABASE `yunweijia` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ |
+-----------+-------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
+-----------+-------------------------------------------------------------------------------------------------------------------------------------+
| Database | Create Database |
+-----------+-------------------------------------------------------------------------------------------------------------------------------------+
| yunweijia | CREATE DATABASE `yunweijia` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ |
+-----------+-------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
这样子就可以看到我们创建数据库的时候，他默认给你添加了什么参数。
3、删除数据库
数据库删除的话，里面的数据也都删除了，一定要谨慎操作。甚至不要执行该操作。
drop database db_name;
mysql> drop database yunweijia;
Query OK, 0 rows affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
6 rows in set (0.00 sec)
mysql>
Query OK, 0 rows affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
6 rows in set (0.00 sec)
mysql>
4、mysql8.0新特性，全部是InnoDB类型
从MySQL 8.0开始，系统表全部换成事务型的InnoDB表，默认的MySQL实例将不包含任何MyISAM表，除非手动创建MyISAM表。
select distinct(ENGINE) from information_schema.tables;
我们先看一个5.7版本的数据库；
然后再来看下8.0版本的信息；
mysql> select distinct(ENGINE) from information_schema.tables;
+--------------------+
| ENGINE |
+--------------------+
| InnoDB |
| NULL |
| PERFORMANCE_SCHEMA |
| CSV |
+--------------------+
4 rows in set (0.01 sec)
mysql>
+--------------------+
| ENGINE |
+--------------------+
| InnoDB |
| NULL |
| PERFORMANCE_SCHEMA |
| CSV |
+--------------------+
4 rows in set (0.01 sec)
mysql>
至此，本文结束。
更多内容请转至VX公众号 “运维家” ，获取最新文章。
------ “运维家” ------
------ “运维家” ------
------ “运维家” ------
系统运维工程师面试，运维工程师优秀员工提名词，tr运维工程师，特来电运维工程师工作日常，IT运维工程师高级；
智能制造运维工程师培训课程，远程办公的运维工程师，迈瑞医疗运维工程师工资待遇，后台运维工程师是做什么的；
风力运维工程师怎样，浪潮云运维工程师，医疗设备运维工程师证书样本，运维工程师男朋友，运维工程师暴躁。
- 赞
- 收藏
- 评论
- 分享
- 举报
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK