Databases Reference
In-Depth Information
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 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['VerboseMult
iSubmit'] is set to TRUE .
 
Search WWH ::




Custom Search