Database Reference
In-Depth Information
Making the Validator available
Some parameters must be configured in
config.inc.php
. Setting
$cfg['SQLQuery']['Validate']
to
TRUE
enables the
Validate SQL
link.
We should also enable the Validator itself (as other validators might be available
on future phpMyAdmin versions). This is done by setting
$cfg['SQLValidator']
['use']
to
TRUE
.
The Validator is accessed with an anonymous Validator account by default, as
configured using the following commands:
$cfg['SQLValidator']['username'] = '';
$cfg['SQLValidator']['password'] = '';
Instead, if the company has provided us with an account, we can use that account
information here.
Validator results
There are two kinds of reports returned by the Validator—one if the query conforms
to the standard, and the other if it does not conform.
Standard-conforming queries
We will try a simple query:
SELECT COUNT(*) FROM book
. As usual, we enter this
query in the query box and send it. On the results page, we now see an additional
link—
Validate SQL
.
Clicking on
Validate SQL
produces the following report:
Conforms to Core SQL-99
SQL queries stored anonymously for statistical purposes.
We have the option of clicking
Skip Validate SQL
to see our original query.
Search WWH ::
Custom Search