Databases Reference
In-Depth Information
Clicking on
Edit
opens the Query window's
SQL
tab, with this query ready to be
modified. This happens because of the following default setting for this parameter:
$cfg['EditInWindow'] = TRUE;
When it is set to
FALSE
, a click on
Edit
will not open the Query window; instead, the
query will appear inside the query box of the
SQL
page.
Clicking on
Inline
replaces the displayed query by a text area where it's possible to
edit and submit this query, without leaving the current results page.
Multi-statement queries
In PHP and MySQL programming, we can send only one query at a time using the
mysql_query()
function call. phpMyAdmin allows us to send many queries in one
transmission, using a semicolon as a separator. Suppose we type the following query
in the query box:
INSERT INTO author VALUES (100,'Paul Smith','111-2222');
INSERT INTO author VALUES (101,'Melanie Smith','222-3333');
UPDATE author SET phone='444-5555' WHERE name LIKE '%Smith%';
We will receive the following results screen:
We see the number of affected rows through comments because
$cfg['VerboseMultiSubmit']
is set to
TRUE
.
Search WWH ::
Custom Search