MySQL Command

By Bys on April 5, 2022

CREATE DATABASES

CREATE DATABASE quartz CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Output
Query OK, 1 row affected (0.02 sec)

SHOW DATABASES

mysql> SHOW DATABASES;

--Output
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| quartz             |
| spring5fs          |
| sys                |
+--------------------+

DROP DATABASE

DROP DATABASE quartz;

-- Output
Query OK, 11 rows affected (0.17 sec)

USE DATABASE

USE quartz;

-- Output
Database changed

Tag: [ mysql command ]