• State Not Answered
  • Replies 10 replies
  • Subscribers 9 subscribers
  • Views 3259 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Comments not getting displayed while executing MySQL Script in Higher Environment

jaishankarj
I have a MySQL Query with my comments in it. I executed the same in higher environment and found that comments are not available and it shows blank space. Any thoughts why it is behaving like this. This happened with me for a stored procedure.

OriginalPostID-235935

  Discussion posts and replies are publicly visible

  • 0
    A Score Level 1
    How are you attempting to view those comments? Are you using SHOW CREATE PROCEDURE or trying to see them in a different way?
  • 0
    @philb: I have provided my comments in BEGIN - END block only in the Definition area of the stored procedure. Sample one is as follows:
    Begin

    /* =============================================*/
    /* Author: Jai Joshi */
    /* Date Created: 19/09/2016 */
    /* Description: */
    /* =============================================*/

    SELECT , from where = CONSTANT;
    END
  • 0
    A Score Level 1
    Ok - how are you attempting to view the comments after creation?
  • 0
    @philb: I clicked on the Stored Proc name and the window appears which is not showing me the comments
  • 0
    A Score Level 1
    In... phpMyAdmin? MySQL workbench? which software?
  • 0
    A Score Level 1
    It looks like this is a phpMyAdmin issue - see here: github.com/.../11717
  • 0
    @philb: Is there any alternate to retain the comments? Is there any support case raised for the same? In absence of seeing these comments we loose the audit of any changes which are being done to the MySQL object
  • 0
    A Score Level 1
    Not that I'm aware of, it's probably worth raising a support case. I'd also question the validity of using comments as an audit trail; you should be using a version control system to track such changes.
    • © 2025 Appian. All rights reserved.
    We want to hear from you! Submit a review on Gartner or G2.