Database Creation (Managing and Using MySQL, 2nd Edition)

3.2. Database Creation

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.37 sec)

The first database, mysql, is MySQL's system database, which you will learn more about in Chapter 5. The second database, test, is a play database you can use to learn MySQL and run tests against. You may find other databases on your server if you are not dealing with a clean installation. For now, however, we want to create a new database to illustrate the use of the MySQL CREATE statement:

CREATE DATABASE TEMPDB;

and then to work with the new database TEMPDB:

USE TEMPDB;

DROP DATABASE TEMPDB;

You can create new objects using the CREATE statement and destroy things using the DROP statement, just as we used them here.