当前位置：网站首页>Basic database operations in MySQL

Basic database operations in MySQL

2022-07-17 23:36:00 【51CTO】

1、 view the database

       
       show databases;
      
1.

This command can view the current database service , There are several databases , as follows ：

       
       mysql> show databases;
       
+--------------------+
       
| Database           |
       
+--------------------+
       
| information_schema |
       
| mysql              |
       
| performance_schema |
       
| sakila             |
       
| sys                |
       
| world              |
       
+--------------------+
       
6 rows in set (0.00 sec)
       
mysql>
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.

2、 Create database

       
       create database db_name;
      
1.

This command can create a database , as follows ：

       
       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>
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.

Someone asked , How to check the status and process of database creation , Use the following command ;

       
       show create database db_name
      
1.

Example ：

       
       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>
      
1.
2.
3.
4.
5.
6.
7.
8.
9.

In this way, we can see when we create the database , What parameters does he add to you by default .

3、 Delete database

If the database is deleted , The data in it has also been deleted , Be sure to operate with caution . Don't even do this .

       
       drop database db_name;
      
1.

as follows ：

       
       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>
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

4、mysql8.0 New characteristics , All is InnoDB type

from MySQL 8.0 Start , The system tables are all transactional InnoDB surface , default MySQL The instance will not contain any MyISAM surface , Unless you create it manually MyISAM surface .

       
       select distinct(ENGINE) from information_schema.tables;
      
1.

Let's see one first 5.7 Version database ;

mysql Basic operation of database in _mysql

And then look at 8.0 Version information ;

       
       mysql> select distinct(ENGINE) from information_schema.tables;
       
+--------------------+
       
| ENGINE             |
       
+--------------------+
       
| InnoDB             |
       
| NULL               |
       
| PERFORMANCE_SCHEMA |
       
| CSV                |
       
+--------------------+
       
4 rows in set (0.01 sec)
       
mysql>
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.

thus , In this paper, the end .

For more information, go to VX official account “ Operation and maintenance home ” , Get the latest article .

------ “ Operation and maintenance home ” ------

Interview with system operation and maintenance engineer , Nominations for excellent staff of operation and maintenance engineer ,tr O & M Engineer , I'm calling the operation and maintenance engineer for daily work ,IT Senior operation and maintenance engineer ;

Intelligent manufacturing operation and maintenance engineer training course , Remote office operation and maintenance engineer , Salary of Mindray medical operation and maintenance engineer , What does the backstage O & M engineer do ;

How about the wind operation and maintenance engineer , Inspur cloud operation and maintenance engineer , Sample certificate of medical equipment operation and maintenance engineer , Boyfriend of operation and maintenance engineer , The O & M engineer is grumpy .

原网站

版权声明
本文为[51CTO]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/198/202207150909570770.html

当前位置：网站首页>Basic database operations in MySQL

Basic database operations in MySQL

2、 Create database

3、 Delete database

边栏推荐

猜你喜欢

随机推荐