Databases Reference
In-Depth Information
Let us send the same list of queries again and watch the results:
It is normal to receive a Duplicate entry error message 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.
Setting fmtType to 'text' would remove all color formatting, inserting line breaks
at logical points inside a MySQL statement. Finally, setting fmtType to 'none'
removes every kind of formatting, leaving our syntax intact.
The SQL Validator
Each time phpMyAdmin transmits a query, the MySQL server interprets it and
provides feedback. The syntax of the query must follow MySQL rules, which are not
the same as the SQL Standard. However, conforming to SQL Standard ensures that
our queries are usable on other SQL implementations.
 
Search WWH ::




Custom Search