How to enable errors in MySQL when a JOIN clause with no ON clause is given?

44 views Asked by At

Writing a JOIN statement and forgetting the corresponding ON clause is a common mistake and some DBMS can show errors or warnings in such cases. In MySQL 8, is it possible to report or prevent queries with missing a missing ON ? For example this simple query misses the ON part.

SELECT * 
FROM employees JOIN departments;

I can't find any sql-mode for this functionality. Or is this just a Bad Idea?

0

There are 0 answers