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

2008-04-30 Thread Saravanan
> To: "mysql list" > Date: Wednesday, April 30, 2008, 3:57 PM > 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 >

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

2008-04-30 Thread Saravanan
> To: "mysql list" > Date: Wednesday, April 30, 2008, 3:57 PM > 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 >

Re: mysql variables

2008-04-30 Thread Dan Nelson
In the last episode (Apr 30), Krishna Chandra Prajapati said: > I am worried about Key_blocks_unused. when Key_blocks_unused reach to > 0. There will be no free blocks then how insert query will work. The oldest block will be written to disk if it is dirty, and discarded. -- Dan Nelson

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

2008-04-30 Thread Baron Schwartz
t; > 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

Bug: describe table show default NULL, but that's not true

2008-04-30 Thread Dominik Klein
Hi I upgraded from 5.0.45 to 5.0.51b yesterday. After installing the files, I just copied the var directory and started the database. mysql> show create table cc\G *** 1. row *** Table: cc Create Table: CREATE TABLE `cc` ( `id` varchar(