SEPERATOR kısmı sql'i bozuyor hem tanımlı değil hemde group_concat fonksiyonuna ikinci bir parametre olarak görünmüyor! tanımladıktan sonra araya virgül atmayı deneyin
2012/12/5 Gamze Tepe <[email protected]> > ** > 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 > >
_______________________________________________ Linux-programlama mailing list [email protected] https://liste.linux.org.tr/mailman/listinfo/linux-programlama Liste kurallari: http://liste.linux.org.tr/kurallar.php
