Developer Question regarding MySQL Syntax?

Discuss MySQL Ajax Table Editor

Developer Question regarding MySQL Syntax?

Postby connorcruise123 » Wed May 23, 2018 8:28 am

Hi,

Most of the time developing with MySQL goes along just fine. Sometimes, however, the amount of data elements to be maintained can exceed hundreds for certain apps. With this amount of data debugging the SQL statements can become tedious due to the sheer number of elements, quoting, commas, etc. Of course the MySQL error messages simply state "Error in your syntax . . ."
So, I am wondering, is anyone aware of a SQL statement verifier that does a reasonable job of verifying? I've searched and tried a number but most of what I found simply repeated that simple message. Of course a good one should incorporate the database definition so that most likely eliminates "simple".
Therefore, any thoughts, suggestions, ideas, etc. which might reduce the amount of time one spends on these types of errors?

Please help.

I didn't find the right solution from the Internet.

References:-
https://bit.ly/2Lm4DS0
Best video service

Thanks
connorcruise123
 
Posts: 5
Joined: Mon May 14, 2018 8:51 am

Return to Open Discussion

Who is online

Users browsing this forum: No registered users and 7 guests

cron