1.数据库的创建
mysql> create database if not exists myTestDB; Query OK, 1 row affected (0.00 sec)
2.查看可用的数据库列表
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | mytestdb | | performance_schema | | sys | +--------------------+ 5 rows in set (0.01 sec)
3.删除数据库
mysql> drop database if exists mytestdb; Query OK, 0 rows affected (0.00 sec)
4.使用数据库
mysql> create database if not exists mytestdb; Query OK, 1 row affected (0.00 sec) mysql> use mytestdb; Database changed