Variable in schema SQL Statement

[Judicael]

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,

[Vegar]

My best guess is that you need quotes around your variable expansion. Like this:

... 

WHERE table_schema='$(vTableSchema)' 

[Nicole-Smith · Accepted solution]

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.