Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What is the correct statement, i see an error message...
LET vTableSchema ='Appollon';
LOAD TABLE_NAME AS TableNames;
SELECT DISTINCT TABLE_NAME FROM information_schema.tables
WHERE table_schema=$(vTableSchema) AND TABLE_NAME IN (
'countries', 'adventures_professionnal');
Regards,
Another alternative to Vegar's response is changing your LET to SET--then the single quotes will stay within the variable and you don't need to add them in the SQL.
My best guess is that you need quotes around your variable expansion. Like this:
...
WHERE table_schema='$(vTableSchema)'
Another alternative to Vegar's response is changing your LET to SET--then the single quotes will stay within the variable and you don't need to add them in the SQL.