SHOW TABLES does not work
Closed this issue · 1 comments
Fragonite commented
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.
Fragonite commented
For anyone running into this problem, a workaround is using a statement like:
SELECT TABLE_NAME FROM information_schema.TABLES