The
suggested database name is built according to the privileges we possess.
If we are restricted to the use of a prefix, the prefix might be suggested in the input
field. (A popular choice for this prefix is the username.) Note that, in this case, the
prefix is followed by an ellipsis mark; we should remove this ellipsis mark and
complete the input field with an appropriate name.
The Collation choice can be left unchanged for now??”more details on this in
Chapter 17.
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 is
created, we will see the following screen:
Chapter 4
[ 67 ]
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.
Pages:
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89