On 27/11/12 13:38, Dron Rathore wrote:

Hi all!, i wanted to know that is there any sql parser to validate queries before firing them? I guess there is one which uses zend. Actually i have coded a parser(client side js validator, can work as JIT, i can transform it into php codes too) and eager to share it with pma. - Regards Dron Rathore

Hi Dron, What is the purpose of validating queries? If the query is invalid MySQL will just throw an error. Besides, we already have an SQL parser in the code base... Byem Rouslan

On 27/11/12 15:25, Marc Delisle wrote:

Rouslan Placella a écrit :

...

On 27/11/12 13:38, Dron Rathore wrote:

...

Hi all!, i wanted to know that is there any sql parser to validate queries before firing them? I guess there is one which uses zend. Actually i have coded a parser(client side js validator, can work as JIT, i can transform it into php codes too) and eager to share it with pma. - Regards Dron Rathore

Hi Dron,

What is the purpose of validating queries? If the query is invalid MySQL will just throw an error.

One of the goals is to verify whether the query is compliant with standard SQL, which is not the same as MySQL. Look for "Validator" in Documentation.html.

...

Besides, we already have an SQL parser in the code base...

Ok, I see. Bye, Rouslan