'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, Bas
g 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 t
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
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 s
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] Upda
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 Jeffer
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'
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 afrai
