xiaoyunwu
asked on
phpmyadmin mysql comment
I tried different kinds of comments in phpmyadmin sql tab to create procedure, every time, after execute, the comment got lost. Not sure how I can keep it there.
DROP PROCEDURE `test`//
# MySQL comment
/* comment */
CREATE PROCEDURE `test`( )
BEGIN
select 1 from table; -- comment
end
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't see any query that can be used to do that. Even the link above is for use on the command line. It is not in the MySQL variables or runtime info on my installations.
ASKER
So there is no way for me to create the procedure through phpmysqladmin with comment line in it?
There is a post on the phpMyAdmin forum but it was never answered. http://sourceforge.net/projects/phpmyadmin/forums/forum/72909/topic/2030012
ASKER
mysql for Toad does not work either. I can't even get the procedure to show up.
ASKER