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