Merhaba arkadaslar, mysql veritabaninda bir fonksiyon yazmaya calisiyorum ama sürekli hata veriyor. Bu konuda yardimci olabilir misiniz? Fonksiyon söyle: CREATE FUNCTION getprojectreportabstracts(_project_id numeric) RETURNS text CHARSET utf8 BEGIN DECLARE result TEXT; SET result = ''; select GROUP_CONCAT(CONCAT(pr.title,' ', pr.abstract_ger) SEPERATOR '\n\n\n') INTO result from project_report_plan prp inner join project_report pr on ( pr.project_report_plan_id = prp.project_report_plan_id) where prp.project_id = _project_id and pr.date_of_submission is not null; return result; end;
ERROR 1064 (42000): 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 '' at line 1 ERROR 1193 (HY000): Unknown system variable 'result' ERROR 1064 (42000): 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 'SEPERATOR '\n\n\n') INTO result from project_report_plan prp inner join project_' at line 1 ERROR 1064 (42000): 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 'return result' at line 1 ERROR 1064 (42000): 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 'end' at line 1 Iyi calismalar, Gamze Tepe
_______________________________________________ Linux-programlama mailing list [email protected] https://liste.linux.org.tr/mailman/listinfo/linux-programlama Liste kurallari: http://liste.linux.org.tr/kurallar.php
