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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]