I see the type "timestamp". Should I leave value, attributes...blank. Do I
just query this field and format as need via DATE()?
Thanks for the heads up.
From: Paul McNeil [mailto:paulie@stripped]
Sent: Thursday, June 10, 2004 7:20 AM
To: MySQL General
Subject: Last Modified
If your table contains a timestamp field, it will update each time the row
is altered. Otherwise I don't think it's possible.
You Wrote ---------
Hello I am using PHP, MySQL. How would I query MySQL to display the last
time a table was last modified/changed/or updated. For example I have a user
that updates a stats page via the web, and I would like it to say (Current
up to "The last date the stats table was modified"). Thanks for your help,
I've been looking online as well but thought this may be quicker. Take care.
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1