List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:April 30 2008 11:27am
Subject:Anybody can tell me how to reserve the comments in the procedure
View as plain text  
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

Thread
Anybody can tell me how to reserve the comments in the procedureMoon's Father30 Apr 2008
  • Re: Anybody can tell me how to reserve the comments in the procedureBaron Schwartz30 Apr 2008
    • Re: Anybody can tell me how to reserve the comments in the procedureMoon's Father4 May 2008
      • Re: Anybody can tell me how to reserve the comments in the procedureBaron Schwartz4 May 2008
  • Re: Anybody can tell me how to reserve the comments in the procedureSaravanan30 Apr 2008
    • Re: Anybody can tell me how to reserve the comments in the procedureMoon's Father4 May 2008
Re: Anybody can tell me how to reserve the comments in the procedureSaravanan30 Apr 2008