Anybody can tell me how to reserve the comments in the procedure
- Date: Wed, 30 Apr 2008 17:27:56 +0800
- From: "Moon's Father" <yueliangdao0608@xxxxxxxxx>
- Subject: Anybody can tell me how to reserve the comments in the procedure
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