Execute Immediate is not working in Procedures. Could some one help please?

memsql

#1

I am getting error as “Error Code: 1149. line 8, syntax error at or near “EXECUTE””.


#2

Can you paste in the code of your SP? It’s supposed to be used like:

EXECUTE IMMEDIATE string_expression

(https://docs.memsql.com/sql-reference/v6.7/execute-immediate/)