Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

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 standard SQL. However, conforming to standard SQL ensures that our queries may be used on other SQL implementations.

A free external service, the Mimer SQL Validator, is offered. It validates our query according to 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

This service stores anonymously on their server the queries it receives, for statistical purposes. When storing the queries, it replaces database, table, and columns names with generic names. Strings and numbers that are part of the query are replaced with generic values, so as to protect the original information.

System Requirements

This Validator is available as a SOAP service. Our PHP server must have XML, PCRE, and...