01-MySQL数据库结构操作

01-MySQL数据库结构操作

---

安装（Ubuntu ）

sudo apt-get update
sudo apt-get install mysql-server 
sudo mysql_secure_installation

启动

sudo systemctl mysql start

卸载

sudo apt purge mysql-*
sudo rm -rf /etc/mysql/ /var/lib/mysql
sudo apt autoremove
sudo apt autoclean

登录

mysql -uroot -p

查看所有数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

创建数据库

创建数据库并制定编码和校验集

mysql> create database test character set utf8 collate utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

删除数据库

mysql> drop database test;
Query OK, 0 rows affected (0.00 sec)

查询默认存储引擎

mysql> show variables like '%storage_engine%';
+----------------------------------+--------+
| Variable_name                    | Value  |
+----------------------------------+--------+
| default_storage_engine           | InnoDB |
| default_tmp_storage_engine       | InnoDB |
| disabled_storage_engines         |        |
| internal_tmp_disk_storage_engine | InnoDB |
+----------------------------------+--------+
4 rows in set (0.00 sec)

选中数据库

use test