moodleou/moodle-report_customsql

SHOW TABLES does not work

Closed this issue · 1 comments

The statement SHOW TABLES or SHOW TABLES LIKE ... generates the following error:

Error when executing the query: Error reading from database You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 2' at line 1 SHOW TABLES LIMIT 0, 2 [array ( )]

I propose adding an option or special case to fix the problem.

For anyone running into this problem, a workaround is using a statement like:

SELECT TABLE_NAME FROM information_schema.TABLES