Re: stored procedure syntax error

I think, you have to use prepare() before run that select statement. i.e SET @s = CONCAT("SELECT * INTO OUTFILE", c ,"FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM cells_summary WHERE PMMDATEANDTIME=b"); PREPARE stmt FROM @s; EXECUTE stmt; regards, nilnandan

stored procedure syntax error

Hi all ! I m getting an error while writing stored procedure, the code is as below and error CODE -- DELIMITER $$ DROP PROCEDURE IF EXISTS `aaa` $$ CREATE definer=`ro...@`%