Hello ALL,


I am using MySQL 5.0.26. If I comment a single line using '//' in a user-defined function, there will be error message occurring when using 'source' to 'install' the function. The error message occurs also when the '/*' and '*/' span more than one code lines.

Why

in the function, I have 'delimiter //' in the first line. i think this is the reason when using '//' as commenting-out leading symbol cause failure.

However, why '/*' and '*/' cannot be used to comment out multiple lines?

offhand I'd guess because MySQL has chosen to implemnent // as thge comment symbol. after all the commentis being used in MySQL's SQL rahther than C, C++, JAVA or any of the C wannabee's

soem SQL's use --, some {, some ' each to their own...

That's the ANSI Standard for single line comments in SQL ....

dunno... please show it