Thanks for your reply. I know this way to comment outside of a store procedure,But this is not my need.
On Wed, Apr 30, 2008 at 10:49 PM, Saravanan <[EMAIL PROTECTED]> wrote: > > Use > > alter procedure procedure_name comment 'comments string' > > Saravanan > > > --- On Wed, 4/30/08, Moon's Father <[EMAIL PROTECTED]> wrote: > > > From: Moon's Father <[EMAIL PROTECTED]> > > Subject: Anybody can tell me how to reserve the comments in the > procedure > > To: "mysql list" <mysql@lists.mysql.com> > > 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 [EMAIL PROTECTED] 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 > > [EMAIL PROTECTED] 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 > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn