RE: [PHP-DB] Update time/date stamp
any particular table? or just the db in general? bastien From: Pete Holsberg [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Update time/date stamp Date: Wed, 2 Feb 2005 10:56:08 -0500 (EST) I would like to print the date and time my database was last updated but don't know the query for that. Ilooked at several websites that list MySQL variables but didn't find any that seemed to be what I want. Can anyone help? Thanks. --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Update time/date stamp
On Wed, 2 Feb 2005, Bastien Koert wrote: any particular table? or just the db in general? It has just one table. --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Update time/date stamp
is there a timestamp or data time field in the table? If so just quuery that field for the max value select max(dateTimeFieldName) from TableName bastien From: Pete Holsberg [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: RE: [PHP-DB] Update time/date stamp Date: Wed, 2 Feb 2005 13:57:50 -0500 (EST) On Wed, 2 Feb 2005, Bastien Koert wrote: any particular table? or just the db in general? It has just one table. --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Update time/date stamp
On Wed, 2 Feb 2005, Bastien Koert wrote: is there a timestamp or data time field in the table? If so just quuery that field for the max value select max(dateTimeFieldName) from TableName No there isn't. When I view the table with phpMyAdmin, it displays a table that includes time/date stamps for creation, last updated and last checked. Thanks. --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Update time/date stamp
so select max(last_updated) bastien From: Pete Holsberg [EMAIL PROTECTED] To: php-db@lists.php.net Subject: RE: [PHP-DB] Update time/date stamp Date: Wed, 2 Feb 2005 14:06:35 -0500 (EST) On Wed, 2 Feb 2005, Bastien Koert wrote: is there a timestamp or data time field in the table? If so just quuery that field for the max value select max(dateTimeFieldName) from TableName No there isn't. When I view the table with phpMyAdmin, it displays a table that includes time/date stamps for creation, last updated and last checked. Thanks. --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Update time/date stamp
On Wed, 2 Feb 2005, Bastien Koert wrote: so select max(last_updated) bastien Error SQL-query : SELECT max( last_updated ) FROM Directory MySQL said: Unknown column 'last_updated' in 'field list' --- I see that I was unclear in my description of what I said. My table is called directory. When I open directory with phpMyAdmin, it displays several tables: 1) the structure of directory 2) Indexes 3) space usage, and 4) row statistic. In the fourth table, it displays the three time-date stamps along with format, number of rows, row length and row size. So the last-updated information is in A table but not the table called directory. Sorry for the confusion. From: Pete Holsberg [EMAIL PROTECTED] To: php-db@lists.php.net Subject: RE: [PHP-DB] Update time/date stamp Date: Wed, 2 Feb 2005 14:06:35 -0500 (EST) On Wed, 2 Feb 2005, Bastien Koert wrote: is there a timestamp or data time field in the table? If so just quuery that field for the max value select max(dateTimeFieldName) from TableName No there isn't. When I view the table with phpMyAdmin, it displays a table that includes time/date stamps for creation, last updated and last checked. Thanks. --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Update time/date stamp
'show table status' will return a record set that you can parse to get the last update time bastien From: Pete Holsberg [EMAIL PROTECTED] To: php-db@lists.php.net Subject: RE: [PHP-DB] Update time/date stamp Date: Wed, 2 Feb 2005 15:00:34 -0500 (EST) On Wed, 2 Feb 2005, Bastien Koert wrote: so select max(last_updated) bastien Error SQL-query : SELECT max( last_updated ) FROM Directory MySQL said: Unknown column 'last_updated' in 'field list' --- I see that I was unclear in my description of what I said. My table is called directory. When I open directory with phpMyAdmin, it displays several tables: 1) the structure of directory 2) Indexes 3) space usage, and 4) row statistic. In the fourth table, it displays the three time-date stamps along with format, number of rows, row length and row size. So the last-updated information is in A table but not the table called directory. Sorry for the confusion. From: Pete Holsberg [EMAIL PROTECTED] To: php-db@lists.php.net Subject: RE: [PHP-DB] Update time/date stamp Date: Wed, 2 Feb 2005 14:06:35 -0500 (EST) On Wed, 2 Feb 2005, Bastien Koert wrote: is there a timestamp or data time field in the table? If so just quuery that field for the max value select max(dateTimeFieldName) from TableName No there isn't. When I view the table with phpMyAdmin, it displays a table that includes time/date stamps for creation, last updated and last checked. Thanks. --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Pete Holsberg Columbus, NJ --- When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty. -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php