Databases Reference
In-Depth Information
Notice the following:
•
The main title of the right panel has changed to reflect the fact that we are
now located in this database.
A confirmation message regarding the creation is displayed.
The left panel has been updated; we see
marc_book (0)
. Here, the name
indicates that the
marc_book
database has been created, and the number 0
indicates that it contains no tables.
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.
As the generated queries could be large and take much room on-screen, the
$cfg['
MaxCharactersInDisplayedSQL']
acts as a limit. Its default value of
1000
should
be a good balance between seeing too few and seeing too much of the queries,
especially when doing large imports.
It is important to examine the phpMyAdmin feedback to ascertain the validity of the
operations we make through the interface. This way, we can detect errors like typos
in the names, or creation of a table in the wrong database.
Search WWH ::
Custom Search