Menu
Is there any site available online for verifying the syntax which conforms to multiple databases?
For example: If I have a SQL statement with a 'usage' keyword, then the site should throw me an error saying that 'usage' keyword is reserved in MYSQL?
617
EverSQL Validator is a free online syntax checker for MySQL SQL statements. The validator will compile and validate SQL queries to report for syntax errors.
For querying multiple tables in different databases on the same server, all we have to do is use the fully qualified table name. The only condition is, the user logged into the query analyzer (or used for executing the query) should have permission on both the databases.
To verify an SQL statementRight-click in the SQL Pane, and select Verify SQL Syntax from the shortcut menu.
You could try a formatter like this
They will always be limited because they don't (and can't) know what user defined functions you may have defined in your database (or which built-in functions you have or don't have access to).
You could also look at ANTLR (but that would be an offline solution)
91
Have you tried http://www.dpriver.com/pp/sqlformat.htm?
7
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
