Creating a database has no effect on which database currently is selected as the default database. To make the new database the default database, issue a USE statement: USE my_db; After a database has been created, it can be populated with objects such as tables or stored routines. The CREATE statement for tables is discussed in a later chapter. Displaying Database Structure The easiest way to display the database structure (as far as the database container) is to issue a SHOW CREATE DATABASE command. This command shows the CREATE DATABASE statement that was used to create the database (or could be used to recreate the database structure): mysql> SHOW CREATE DATABASE my_db\G ************************* 1. row ************************* Database: my_db Create Database: CREATE DATABASE `my_db` ...
“The best way to be ready for the future is to invent it.”— John Sculley