From: Martin Gainty
Date: May 5 2009 3:26pm
Subject: RE: Creation date
List-Archive: http://lists.mysql.com/mysql/217404
Message-Id: <BLU142-W156C9E72064DADA82B06D1AE690@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_73b9f79f-a928-43c5-a6ac-0913aff33079_"

--_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@stripped
> To: mysql@stripped
> 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
>  <http://www.the-infoshop.com> www.the-infoshop.com
>=20
> =20
>=20

_________________________________________________________________
Hotmail=AE goes with you.=20
http://windowslive.com/Tutorial/Hotmail/Mobile?ocid=3DTXT_TAGLM_WL_HM_Tutor=
ial_Mobile1_052009=

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