Link to home
Start Free TrialLog in
Avatar of xiaoyunwu
xiaoyunwuFlag for United States of America

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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of xiaoyunwu

ASKER

But how can I enable them in phpmysqladmin? What query should I do to enable them? THanks.
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.
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
mysql for Toad does not work either. I can't even get the procedure to show up.