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...@`%<mailto:definer=`ro...@`%>` PROCEDURE `aaa`() BEGIN DECLARE b VARCHAR(255); DECLARE c VARCHAR(255); SET b= CONCAT(SUBDATE(CURDATE(), INTERVAL 15 DAY)," 00:00:00"); SET c= CONCAT("'","C://cells_summary.csv","'"); SELECT * INTO OUTFILE (c) FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM cells_summary WHERE PMMDATEANDTIME=b; //wrong END $$ DELIMITER ; ------------------------------------------------------------------------------------------------------ ERROR --------------------------------------------------------------------------------------------------------------------------- Script line: 4 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(c) FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'' at line 7 --------------------------------------------------------------------------------------------------------- I guess there is a wronge syntax, SELECT * INTO OUTFILE (c) FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM cells_summary WHERE PMMDATEANDTIME=b; kindly anyone can help with correct syntax..... Thanx
