Re: Could somebody tell me how to get the time of a database?

2008-05-12 Thread Moon's Father
I mean database,not table. thank you all the same. On Mon, May 12, 2008 at 1:55 PM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: show table status; On Mon, May 12, 2008 at 11:19 AM, Moon's Father [EMAIL PROTECTED] wrote: I want to know the create time of a database,but I can not

Re: Could somebody tell me how to get the time of a database?

2008-05-12 Thread Iñigo Medina García
Hi Moon's Father, :-) what about through filesystem? $ ls -la /path-mysql-databases or something like that. Iñigo I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- Iñigo Medina García Librería

Re: Could somebody tell me how to get the time of a database?

2008-05-12 Thread Moon's Father
Thanks for your reply very much. I know this way. Could you know how to get this just by sql? On Mon, May 12, 2008 at 2:57 PM, Iñigo Medina García [EMAIL PROTECTED] wrote: Hi Moon's Father, :-) what about through filesystem? $ ls -la /path-mysql-databases or something like that. Iñigo

Re: Could somebody tell me how to get the time of a database?

2008-05-12 Thread Iñigo Medina García
Thanks for your reply very much. I know this way. :-) Could you know how to get this just by sql? Mmmhh, no idea right now. I think unless you logged the CREATE DATABASE I don't think the creation date is stored anywhere. Anybody could check that? Iñigo On Mon, May 12, 2008 at 2:57

Re: Could somebody tell me how to get the time of a database?

2008-05-11 Thread Krishna Chandra Prajapati
show table status; On Mon, May 12, 2008 at 11:19 AM, Moon's Father [EMAIL PROTECTED] wrote: I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- I'm a mysql DBA in china. More about me just visit here: