Re: Anybody can tell me how to reserve the comments in the procedure

[Baron Schwartz]

Hi,

Try forming the comments like this:

/*!99999
 * comment text here
 */

See if that works for you.

Regards
Baron

On Wed, Apr 30, 2008 at 5:27 AM, Moon's Father
<yueliangdao0608@stripped> wrote:
> When I execute the following statements in the command line:
>
>  DELIMITER $$
>
>  DROP PROCEDURE IF EXISTS `t_girl`.`sp_test`$$
>
>  CREATE DEFINER=`web_131`@`%` PROCEDURE `sp_test`()
>  BEGIN
>   -- Created by david yeung 20080430.
>   select version();
>  END$$
>
>  DELIMITER ;
>  But the result is not my expected,there are no comments in the routine's
>  body.
>
>  mysql> show create procedure sp_test;
> 
> +-----------+-----------------------+-------------------------------------------------------------------------------------+
>  | Procedure | sql_mode              | Create
>  Procedure
>  |
> 
> +-----------+-----------------------+-------------------------------------------------------------------------------------+
>  | sp_test   | NO_AUTO_VALUE_ON_ZERO | CREATE DEFINER=`web_131`@`%` PROCEDURE
>  `sp_test`()
>  BEGIN
>
>   select version();
>  END |
> 
> +-----------+-----------------------+-------------------------------------------------------------------------------------+
>  1 row in set (0.00 sec)
>
>  Can anybody give me a solution to solve this problem.
>  Any *appreciate* is welcome.
>  --
>  I'm a mysql DBA in china.
>  More about me just visit here:
>  http://yueliangdao0608.cublog.cn
>



-- 

Baron Schwartz, Senior Consultant, Percona Inc.
Tel: [phone] ext 507
24/7 Emergency Line [phone] ext 911
Our Services: http://www.percona.com/services.html
Our Blog: http://www.mysqlperformanceblog.com/