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

[Moon's Father]

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 <baron@stripped> 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
> <yueliangdao0608@stripped> wrote:
> > 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
> >
>
>
>
> --
>
> Baron Schwartz, Senior Consultant, Percona Inc.
> Tel: [phone] ext 507
> 24/7 Emergency Line [phone] 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