SQL Statement : How to retrieve TABLES name as variables ?

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

 

You might want to check out the workflow hosted on our EXAMPLE Server (004_Databases/004003_Database_QueryBuildWithQuickforms) and especially the Database Select > List Tables meta nodes. Hope this helps.