Finding the creation date of an existing database in MySQL 5?

Hi all ! Is there any method to find the CREATION DATE of an EXISTING database and tables in MySQL 5.0 or newer versions? Thanks, Uma

Re: Finding the creation date of an existing database in MySQL 5?

Is there any method to find the CREATION DATE of an EXISTING database and tables in MySQL 5.0 or newer versions? information_schema.tables.create_time for tables. PB Uma Bhat wrote: Hi all ! Is there any method to find the CREATION DATE of an EXISTING database and tables in MySQL 5.0

Re: Finding the creation date of an existing database in MySQL 5?

Thanks for the response, Peter. Yeah, I am aware of this to find it for the tables. However I require to find the creation time of a database.. Thanks, Uma On 6/3/09, Peter Brawley peter.braw...@earthlink.net wrote: Is there any method to find the CREATION DATE of an EXISTING

Creation date

At the risk of getting spanked for not finding this in the documentation, I'm asking a simple question: Can I tell when a table was created? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX:

Re: Creation date

At 10:28 AM -0400 5/5/09, Jerry Schwartz wrote: At the risk of getting spanked for not finding this in the documentation, I'm asking a simple question: Can I tell when a table was created? Try show table status or select table_name,create_time from information_schema.tables

RE: Creation date

facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: jschwa...@the-infoshop.com To: mysql@lists.mysql.com Subject: Creation date Date: Tue, 5 May 2009 10:28:28 -0400 At the risk of getting spanked for not finding

Re: Creation date

I would have said to look at the creation date of the .frn file, but there is also a field called create date in the show table status command and the 2 dates often differ. Anyone know why they do? On Tue, May 5, 2009 at 9:28 AM, Jerry Schwartz jschwa...@the-infoshop.comwrote: At the risk

RE: Creation date

The create date in show table status is metadata held in the table itself wheras the create data on the .frm file is when that file was created - i.e. if you copy the data files (without preserving attributes) it will have a new creation date on the filesystem but the metadata of the table

RE: Creation date

Thanks, I knew it had to be something simple. Now I can clean out my save this in case you make a mistake tables. -Original Message- From: Steve Edberg [mailto:sbedb...@ucdavis.edu] Sent: Tuesday, May 05, 2009 11:00 AM To: Jerry Schwartz; mysql@lists.mysql.com Subject: Re: Creation date

Re: Saving creation date

Hello. But I don't want the value to be updated automatically after an update. Use DEFAULT CURRENT_TIMESTAMP. You can see that after an update, the value of the timestamp column didn't changed: mysql create table timeup(a int,b timestamp default current_timestamp); Query OK, 0 rows

Saving creation date

Hi, I want to save date and time of the creation of a row in a field. That could be handled by a timestamp, I know that. But I don't want the value to be updated automatically after an update. I tried . creation datetime not null default now() . in the create table statement, but got an