Prev | Current Page 182 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"


This distinct query window only appears if $cfg['QueryFrameJS'] is set to TRUE;
we need to use a JavaScript-enabled browser. If this is set to FALSE, following the
Query window link will only jump to the normal SQL page with the query box.
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 is not checked, and the changes we make
while navigating generating queries are reflected in the query window. (This is called
synchronization.) For example, choosing a different database or table from the left
or right panel would update the query window accordingly. But 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.
Chapter 12
[ 199 ]
Session-Based SQL History
This feature collects, as session data, all the successful SQL queries we execute and
modifies the Query window to make them available.


Pages:
170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194