Database Reference
In-Depth Information
We will receive the following results screen:
We see the number of affected rows through comments because
$cfg['VerboseMultiSubmit']
is set to
TRUE
.
Let's send the same list of queries again and watch the results:
It is normal to receive a
Duplicate entry
error that says, the value
100
exists already. We are seeing the results of the first
INSERT
statement; but
what happens to the next one? Execution stops at the first error because
$cfg['IgnoreMultiSubmitErrors']
is set to
FALSE
telling phpMyAdmin
not to
ignore errors in multiple statements. If it is set to
TRUE
, the program
successively tries all the statements, and we see two
Duplicate entry
errors.
This feature would not work as expected, if we tried more than one
SELECT
statement. We would see the results of only the last
SELECT
statement.
Pretty printing (syntax-highlighting)
By default, phpMyAdmin parses and highlights the various elements of any MySQL
statement it processes. This is controlled by
$cfg['SQP']['fmtType']
, which is set
to
'html'
by default. This mode uses a specific color for each different element (a
reserved word, a variable, a comment, and so on) as described in the
$cfg['SQP']
['fmtColor']
array located in the theme-specific
layout.inc.php
file.
Search WWH ::
Custom Search