Creation date

------=_NextPart_000_232A_01C9CD6C.3C689A20
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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.674.8341



www.the-infoshop.com




------=_NextPart_000_232A_01C9CD6C.3C689A20--

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

(information_schema only exists in MySQL >= 5.0, methinks). Manual references:

http://dev.mysql.com/doc/refman/5.0/en/show-table-status.htm l

http://dev.mysql.com/doc/refman/5.0/en/information-schema.ht ml


- steve

--
+--------------- my people are the people of the dessert, ---------------+
| Steve Edberg http://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center sbedberg@ucdavis.edu |
| Bioinformatics programming/database/sysadmin (530)754-9127 |
+---------------- said t e lawrence, picking up his fork ----------------+

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Creation date

--_73b9f79f-a928-43c5-a6ac-0913aff33079_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


that is one weird opening statement

select * from information_schema.tables where table_name=3D'DATABASE_NAME.T=
ABLENAME'=3B

Martin=20
"May the Schwartz be with you" -- Spaceballs
______________________________________________=20
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note d=
e d=E9ni et de confidentialit=E9
This message is confidential. If you should not be the intended receiver=2C=
then we ask politely to report. Each unauthorized forwarding or manufactur=
ing of a copy is inadmissible. This message serves only for the exchange of=
information and has no legal binding effect. Due to the easy manipulation =
of emails we cannot take responsibility over the the contents.
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..




> From: jschwartz@the-infoshop.com
> To: mysql@lists.mysql.com
> Subject: Creation date
> Date: Tue=2C 5 May 2009 10:28:28 -0400
>=20
> At the risk of getting spanked for not finding this in the documentation=
=2C
> I'm asking a simple question:
>=20
> =20
>=20
> Can I tell when a table was created?
>=20
> =20
>=20
> Regards=2C
>=20
> =20
>=20
> Jerry Schwartz
>=20
> The Infoshop by Global Information Incorporated
>=20
> 195 Farmington Ave.
>=20
> Farmington=2C CT 06032
>=20
> =20
>=20
> 860.674.8796 / FAX: 860.674.8341
>=20
> =20
>=20
> www.the-infoshop.com
>=20
> =20
>=20

____________________________________________________________ _____
Hotmail=AE goes with you.=20
http://windowslive.com/Tutorial/Hotmail/Mobile?ocid=3DTXT_TA GLM_WL_HM_Tutor=
ial_Mobile1_052009=

--_73b9f79f-a928-43c5-a6ac-0913aff33079_--

Re: Creation date

--00163628368943b91504692c1023
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 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.674.8341
>
>
>
> www.the-infoshop.com
>
>
>
>


--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

--00163628368943b91504692c1023--

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 not change.

Andrew

-----Original Message-----
From: Jim Lyons [mailto:jlyons4435@gmail.com]=20
Sent: 05 May 2009 16:38
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: 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 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.674.8341
>
>
>
> www.the-infoshop.com
>
>
>
>


--=20
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

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:sbedberg@ucdavis.edu]
>Sent: Tuesday, May 05, 2009 11:00 AM
>To: Jerry Schwartz; mysql@lists.mysql.com
>Subject: 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
>
>(information_schema only exists in MySQL >= 5.0, methinks). Manual
>references:
>
> http://dev.mysql.com/doc/refman/5.0/en/show-table-status.htm l
>
> http://dev.mysql.com/doc/refman/5.0/en/information-schema.ht ml
>
>
> - steve
>
>--
>+--------------- my people are the people of the dessert, --------------
>-+
>| Steve Edberg http://pgfsun.ucdavis.edu/
>|
>| UC Davis Genome Center sbedberg@ucdavis.edu
>|
>| Bioinformatics programming/database/sysadmin (530)754-9127
>|
>+---------------- said t e lawrence, picking up his fork ---------------
>-+




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org