CREATE PROCEDURE getCountry(IN `locale` char(2))
BEGIN
SET @sql = 'SELECT * FROM articles';
PREPARE getCountrySql FROM @sql;
EXECUTE getCountrySql;
DEALLOCATE PREPARE getCountrySql;
END
SET @sql
CREATE PROCEDURE proc_IF (IN param1 INT)
BEGIN
SET @query = CONCAT('SELECT * FROM articles');
PREPARE stmt FROM @query;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END