MySQL数据库的练习（数据库的创建，使用，查看，查看表格，初始化数据库）

MySQL的练习（数据库的创建，使用，查看，查看表格，初始化数据库）

登入指令：
mysql -u root -p + 数据库密码；

练习指令：
//创建数据库
create database database_text1;

例：
C:\Users\lenon>mysql -u root -p
Enter password: ***********

//使用数据库
use database_text1;

//查看数据库
show databases;

//查看当前使用数据库内的表格
show tables;

//初始化数据库（source）->Soyrce是额外自定义程序（这里使用的是动力结点的程序）
source E:\······后端······\2.1 ····SQL系列····\MYSQL\工具代码\初始化（source）\Source.sql;

总体代码：

Microsoft Windows [版本 10.0.22000.1219]
(c) Microsoft Corporation。保留所有权利。

//登入程序
C:\Users\lenon>mysql -u root -p
Enter password: ***********


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 36
Server version: 8.0.31 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| world              |
+--------------------+
6 rows in set (0.00 sec)

//create的使用
mysql> create database database_text1;
Query OK, 1 row affected (0.00 sec)

 //查看数据库
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| database_text1     |
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| world              |
+--------------------+
7 rows in set (0.00 sec)

//使用数据库
mysql> use database_text1;
Database changed

//查看当前使用数据库内的表格
mysql> show tables;
Empty set (0.00 sec)

//初始化数据库（source）->Soyrce是额外自定义程序（这里使用的是动力结点的程序）
mysql>  source E:\······后端······\2.1 ····SQL系列····\MYSQL\工具代码\初始化（source）\Source.sql;

Query OK, 0 rows affected, 1 warning (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.02 sec)

Query OK, 0 rows affected, 5 warnings (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> show tables;
+--------------------------+
| Tables_in_database_text1 |
+--------------------------+
| dept                     |
| emp                      |
| salgrade                 |
+--------------------------+
3 rows in set (0.00 sec)

mysql> drop database database_text1;
Query OK, 3 rows affected (0.02 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| world              |
+--------------------+
6 rows in set (0.00 sec)

mysql> quit
Bye

感谢观看~