Creating and Browsing Tables - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 69

The Collation choice can be left unchanged for now. With this dialog, we could pick
a default character set and collation for this database. This setting can be changed
later (refer to Chapter 9 for more information on this).
We will assume here that we have the right to create a database named marc_book .
We enter marc_book in the input field and click on Create . Once the database has
been created, we will see the following screen:
Notice the following:
• The title of the main panel has changed to relect the fact that we are now
located in this database
• A conirmation message regarding the creation is displayed
• The navigation panel has been updated; we see marc_book
• By default, the SQL query sent to the server by phpMyAdmin to create the
database is displayed in color
phpMyAdmin displays the query it generated, because
$cfg['ShowSQL'] is set to TRUE . Looking at the generated
queries can be a good way of learning SQL.