Mastering phpMyAdmin 3.4 for Effective MySQL Management

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.

A free external service, the Mimer SQL Validator, is available to us, thanks to Mimer Information Technology AB. It validates our query according to the Core SQL-99 rules and generates a report. The Validator is available directly from phpMyAdmin, and its home page is located at http://developer.mimer.com/validator/index.htm.

Note

For statistical purposes, this service anonymously stores on its server, the queries it receives. When storing the queries, ...