Thanks for your reply.This works for me. Can you tell me why the number is 99999? when I try others,it can not work at all.
On Wed, Apr 30, 2008 at 8:08 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > 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/ > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn