Dear Knime Users,
I am a beginner and I would like to retrieve table names from a mySQL Database (e.g : SHOW TABLES FROM knime_test;) in order to use them as variable in my workflow. I have tried to use the "Database Table Selector" but I have the following error mesage :
WARN Database Table Selector 0:1404:1469 Error while validating SQL query " SHOW TABLES FROM knime_test;" : 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' at line 1
This statement is valid and is well working when I use a mySQL Command Line Client or my SQL workbench (windows7).
Should I use another node or is there another way to fetch this data or MetaDada ?
Thank you for your help.
Best regards,
Antoine