Databases Reference
In-Depth Information
The Database view
We encounter our first SQL query box when going to the
SQL
menu available in the
Database
view.
This box is simple—we type in some valid (hopefully) MySQL statement and click
on
Go
. Under the query text area, there are bookmark-related choices (explained
later in
Chapter
14
). Usually, we don't have to change the standard SQL delimiter,
which is a semicolon. However, there is a
Delimiter
dialog in case we need it (refer
to
Chapter
17
).
For a default query to appear in this box, we can set it with the
$cfg['DefaultQueryDatabase']
configuration directive, which is empty by default.
We could put a query such as
SHOW
TABLES
FROM
@DATABASE@
in this directive. The
@
DATABASE@
placeholder in this query would be replaced by the current database name,
resulting in
SHOW
TABLES
FROM
`marc_book`
in the query box.
Search WWH ::
Custom Search