Databases Reference
In-Depth Information
They are clickable for immediate execution, and the
Edit
icon is available to insert a
recorded query into the query box for editing.
How many queries will be kept is controlled by
$cfg['QueryHistoryMax']
, which
is set to
25
by default. This limit is not kept for performance reasons but as a practical
limit so as to achieve a visually unencumbered view. Extra queries are eliminated at
login time in a process traditionally called
garbage collection
. The queries are stored
in the table configured in
$cfg['Servers'][$i]['history']
.
Editing Queries in the Query Window
On the results page of a successful query, a header containing the executed
query appears:
Clicking
Edit
opens the Query window's
SQL
tab, with this query ready to be
modified. This happens because of the default setting for this parameter:
$cfg['EditInWindow'] = TRUE;
When it is set to
FALSE
, a click on
Edit
would not open the query window; instead,
the query would appear inside the query box of the
SQL
sub-page.
Multi-Statement Queries
In PHP/MySQL programming, we can only send one query at a time using the
mysql_query()
function call. phpMyAdmin allows for sending many queries in one
transmission, using a semicolon as a separator. Suppose we type the following query
in the query box:
insert into authors values (100,'Paul Smith','111-2222');
insert into authors values (101,'Melanie Smith','222-3333');
update authors set phone='444-5555' where author_name like '%Smith%';
Search WWH ::
Custom Search