• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 482
  • Last Modified:

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

0
xiaoyunwu
Asked:
xiaoyunwu
  • 3
  • 3
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
The default option for comments is for the driver to strip comments before sending SQL to the server.  http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_comments   That's why they're disappearing.
0
 
xiaoyunwuAuthor Commented:
But how can I enable them in phpmysqladmin? What query should I do to enable them? THanks.
0
 
Dave BaldwinFixer of ProblemsCommented:
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.
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
xiaoyunwuAuthor Commented:
So there is no way for me to create the procedure through phpmysqladmin with comment line in it?
0
 
Dave BaldwinFixer of ProblemsCommented:
There is a post on the phpMyAdmin forum but it was never answered.  http://sourceforge.net/projects/phpmyadmin/forums/forum/72909/topic/2030012
0
 
xiaoyunwuAuthor Commented:
mysql for Toad does not work either. I can't even get the procedure to show up.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now