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 <[EMAIL PROTECTED]> wrote: > 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 > -- Baron Schwartz, Senior Consultant, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]