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 wrote: >> >> >Is there any method to find

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 or

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: 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

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 will

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 wrote: > At the risk

RE: Creation date

légalement obligatoire. Étant donné que les email peuvent 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:2

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

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: 860.67

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 aff

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 er