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

[Saravanan]

Use

alter procedure procedure_name comment 'comments string' 

Saravanan


--- On Wed, 4/30/08, Moon's Father <yueliangdao0608@stripped> wrote:

> From: Moon's Father <yueliangdao0608@stripped>
> Subject: Anybody can tell me how to reserve the comments in the procedure
> To: "mysql list" <mysql@stripped>
> Date: Wednesday, April 30, 2008, 3:57 PM
> 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


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now. 
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ