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 <[EMAIL PROTECTED]> 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 > > <[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. -- 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]
