See
http://dev.mysql.com/doc/refman/5.0/en/comments.html.
Regards,
Baron
On Sun, May 4, 2008 at 1:05 AM, Moon's Father <yueliangdao0608@gmail.com> wrote:
> 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 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@gmail.com> 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.
--
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/