Mysql系列001：数据库的基本操作

⭐数据库的操作

---

⭐前言

本系列对刚入门的新手十分友好，欢迎各位学习，如有不对的地方，请指出谢谢，本人菜鸡一枚，望各位多多见谅

⭐常用指令

📚连接数据库

mysql -u用户名 -p密码

📚mysql的欢迎界面
显示这样就是mysql启动成功了

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.32-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

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

exit;/quit;

sql语句最后需要有分号； 结尾（数据库支持函数)

📚显示数据库版本

select version();

📚显示时间

select now();

📚查看所有数据库

show databases();

📚创建数据库
– create database 数据库名 charset=utf8

create database college charset=utf8;

📚查看创建数据库的语句
– show create database …

show create database college;

+----------+-------------------------------------------------------------------+
| Database | Create Database                                                   |
+----------+-------------------------------------------------------------------+
|  college | CREATE DATABASE `college`  /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-------------------------------------------------------------------+

📚查看当前数据库编码(必须提前进入数据库)

use college;
show variables like 'character_set_database'; 

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| character_set_database | utf8  |
+------------------------+-------+

📚查看当前使用的数据库

show database();

📚使用数据库
– use 数据库的名字

use college;

📚删除数据库
– drop database 数据库名

drop database college;

---

🌺感谢收看🌺