You can find complete examples of dynamic SQL in MemSQL here: .
I rewrote your code below. Please take note of the SQL_MODE variable being set. That is required when using pipes to concatenate your strings. Also, MemSQL does not allow SELECT statements in a procedure without ECHO. You will see that in the code below. You can read up on ECHO SELECThere
SET sql_mode = 'PIPES_AS_CONCAT';
DELIMITER //
CREATE OR REPLACE PROCEDURE foo() AS
DECLARE
ConsultaSQL VARCHAR(500);
Tabla VARCHAR(25) = 'Empleados';
Edad1 INT = 50;
Edad2 INT = 70;
BEGIN
ConsultaSQL = 'ECHO SELECT * FROM ' || Tabla || ' WHERE Edad BETWEEN ' || Edad1 || ' AND ' || Edad2;
EXECUTE IMMEDIATE ConsultaSQL;
END;
//
DELIMITER ;