Databases Reference
In-Depth Information
The window seen in the screenshot contains the same
Columns
selector and
<<
button as that used in a
Table
view context. This distinct Query window is a feature
supported only on JavaScript-enabled browsers.
Query window options
The
SQL
tab is the default active tab in this window. This comes from the
configuration directive
$cfg['QueryWindowDefTab']
, which contains
sql
by default.
If we want another tab to be the default active tab, we can replace
sql
with
files
or
history
. Another value,
full
, shows the contents of all the three tabs at once.
In the Query window, we see a checkbox for the
Do
not
overwrite
this
query
from
outside
the
window
choice. Normally, this checkbox is selected. If we deselect it,
the changes we make while generating queries are reflected in the Query window.
This is called
synchronization
. For example, choosing a different database or table
from the navigation or main panel would update the Query window accordingly.
However, if we start to type a query directly in this window, the checkbox will get
checked in order to protect its contents and remove synchronization. This way, the
query composed here will be locked and protected.
Session-based SQL history
This feature collects all the successful SQL queries we execute as PHP session data,
and modifies the Query window to make them available. This default type of history
is temporary, as
$cfg['QueryHistoryDB']
is set to
FALSE
by default.
Database-based SQL history (permanent)
As we installed the phpMyAdmin configuration storage (refer to
Chapter
1
), a more
powerful history mechanism is available. We should now enable this mechanism by
setting
$cfg['QueryHistoryDB']
to
TRUE
.
After we try some queries from one of the query boxes, a history is built, visible only
from the Query window as shown in the following screenshot:
Search WWH ::
Custom Search