Re: prepared statement within stored procedure mysql

[Yurii Korotia]

DELIMITER $$

CREATE PROCEDURE auto_partition()
BEGIN

SET @l_SQL = CONCAT('ALTER TABLE tbl_location_history ADD PARTITION (PARTITION ',
'Part_Y', year( now( ) ) , '_M', month( now( ) ) , '_W', week( now( ))+1, ' VALUES LESS THAN (TO_DAYS(\'', DATE_FORMAT(date_add(NOW(), interval 15 day),'%Y-%m-%d'), '\')))');

PREPARE _stmt FROM @l_SQL;
EXECUTE _stmt;
DEALLOCATE PREPARE _stmt;

END$$

- - -

should work. not sure about @l_SQL and its ()