Client Option: –Enable-Comments

[albinojones]

When writing a Procedure or Trigger, I prefer to retain comments. Comments are valuable :). It would be best if they could be preserved in the database itself, instead of only existing in the .sql files on my harddrive. This way, if someone views procedural directly from the database, the comments will be available to them.

Newer versions of MySQL client provide option –enable-comments for this, which overrides the client's usual behavior of stripping comments.

However, SQLyog seems to only use default behavior in this regard.

Could a check-box be tied to this option and placed in Preferences under General or Other, or in the MySQL Host profiles and called something like 'Retain Comments on Server'?

…Or… Am I missing something (that's happened more than once!) ?

[Mahesh]

We are executing:

“SHOW CREATE PROCEDURE `dbname.spname”;

Resultset return by server does not show comments in this case.

Can you please provide the details like which MySQL client has this settings(MySQL command-line tool/MySQL QB/MySQL workbench) ?

Thanks,

Mahesh

[peterlaursen]

If I execute

Code:

DELIMITER $$

CREATE PROCEDURE `test`.`sp1`()

    BEGIN
— do nothing at all
   END$$

DELIMITER ;

and next 

Code:

SHOW CREATE PROCEDURE sp1;

I do get

Code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`()
BEGIN
— do nothing at all
    END

.. returned, what means that the comment is stored in the database . Also all 'mysql' client command line parameters do not apply to the C-API (SQLyog does not use the 'mysql' client). Please explain the problem so that we can understand.  And also tell the server version.  Early 5.0 servers had lots of bugs in this respect.

[albinojones]

'peterlaursen' wrote on '24:

If I execute

Code:

DELIMITER $$

CREATE PROCEDURE `test`.`sp1`()

    BEGIN
— do nothing at all
   END$$

DELIMITER ;

and next 

Code:

SHOW CREATE PROCEDURE sp1;

I do get

Code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`()
BEGIN
— do nothing at all
    END

.. returned, what means that the comment is stored in the database . Also all 'mysql' client command line parameters do not apply to the C-API (SQLyog does not use the 'mysql' client). Please explain the problem so that we can understand.  And also tell the server version.  Early 5.0 servers had lots of bugs in this respect.

Upon executing the same commands as you have above, I also see comments being retained. Comments not being retained was an issue I experienced in the past which caused me to avoid executing procedure creation via SQLyog… but now that I've tried again, I see I'm not experiencing the issue, so it couldn't be something related to SQLyog. If I run into this again, I will definitely note the server version.

But for now… nevermind.

[Author]

Posts