Martijn Tonies [EMAIL PROTECTED] wrote:
If your table contains a timestamp field, it will update each time the
row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
But if it is on every row, you can MAX() it to get the latest row update,
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
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
: 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
Daniel Venturini [EMAIL PROTECTED] 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
Mind you --
If your table contains a timestamp field, it will update each time the row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
, it will update each time the row
PM is altered. Otherwise I don't think it's possible.
PM You Wrote -
PM Hello I am using PHP, MySQL. How would I query MySQL to display the last
PM time a table was last modified/changed/or updated. For example I have a user
PM that updates a stats page via the web
---I see the type timestamp. Should I leave value, attributes...blank. Do
I
just query this field and format as need via DATE()?
---
Yes. This field is a date actually. It will update each time the record is
modified or when a record is created. You can query it as a normal datetime
field.
On 10 Jun 2004 at 7:02, Daniel Venturini 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
Martijn Tonies [EMAIL PROTECTED] wrote on 10/06/2004 12:33:38:
Mind you --
If your table contains a timestamp field, it will update each time the
row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
But if it is on every row, you can
Mind you --
If your table contains a timestamp field, it will update each time the
row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
But if it is on every row, you can MAX() it to get the latest row update,
which is the latest
Martijn Tonies [EMAIL PROTECTED] wrote on 10/06/2004 13:02:25:
Mind you --
If your table contains a timestamp field, it will update each time
the
row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
But if it is on every
On Fri, Feb 06, 2004 at 08:18:10PM +, Phil wrote:
Doesn't seem to change the mtime on table files. It appears that for
InnoDB tables these files are only updated when the definition of a
table is changed. The content of the all InnoDB tables is kept in one or
two massive files directly
Thanks for checking this out. However, with InnoDB tables you only get
the .frm files under a database directory and these are only modified
when you change the definition of a table. The data itself is kept in a
big binary file(s) one directory up, whose modification time cannot be
used to deduce
Hi,
I have many smallish, discrete MySQL databases, each of which I would
like to backup individually (mysqldump seems fine for this). However,
there's no point re-backing up a database that has not changed since the
last time it was backed up. So how can I tell if when a MySQL database
was last
. So how can I tell if when a MySQL database
was last modified, so that I can decide whether to run mysqldump on it
again or not? Any help with this would be much appreciated.
Thanks,
Phil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I'm not 100% sure on this, but what about the .myd file timestamp?
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 9:09 AM
To: Phil
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
Add
for this). However,
there's no point re-backing up a database that has not changed since the
last time it was backed up. So how can I tell if when a MySQL database
was last modified, so that I can decide whether to run mysqldump on it
again or not? Any help with this would be much appreciated.
Thanks
timestamp?
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 9:09 AM
To: Phil
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
Add a timestamp field to each table.
Phil wrote
You can try the 'show table status' from mysql. There is an update_time that lists
the last modified date for the table.
I also found out that these types of commands work with perl DBD::mysql. You can
treat the command like a normal sql statement and the results are returned like any
[EMAIL PROTECTED] wrote: -
To: gerald_clark [EMAIL PROTECTED]
From: Phil [EMAIL PROTECTED]
Date: 02/06/2004 09:27AM
cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
Thanks. But I would have thought that such information would have been
kept
Sorry. Obviously didn't see this...
-Phil [EMAIL PROTECTED] wrote: -
To: Dan Greene [EMAIL PROTECTED]
From: Phil [EMAIL PROTECTED]
Date: 02/06/2004 09:36AM
cc: gerald_clark [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: How to determine when a MySQL database was last modified
...
backing everything up :( Also, I'll suggest it as an enhancement.
Thanks.
On Fri, 2004-02-06 at 14:28, Schwartz, Evelyn wrote:
You can try the 'show table status' from mysql. There is an update_time that lists
the last modified date for the table.
I also found out that these types
, 2004-02-06 at 14:28, Schwartz, Evelyn wrote:
You can try the 'show table status' from mysql.
There is an update_time that lists the last modified
date for the table.
I also found out that these types of commands work
with perl DBD::mysql. You can treat the command
like a normal sql
.
Since what I want to do doesn't seem possible I'll
carry on as usual...
backing everything up :( Also, I'll suggest it as an
enhancement.
Thanks.
On Fri, 2004-02-06 at 14:28, Schwartz, Evelyn wrote:
You can try the 'show table status' from mysql.
There is an update_time that lists the last modified
; [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
mysqlshow gives the same results as SHOW TABLE STATUS, which,
unfortunately, doesn't seem to give created/updated dates for InnoDB
tables.
Michael
Gowtham Jayaram wrote:
If offline tools works for you try
: Re: How to determine when a MySQL database was last modified?
mysqlshow gives the same results as SHOW TABLE STATUS, which,
unfortunately, doesn't seem to give created/updated dates for InnoDB
tables.
Michael
Gowtham Jayaram wrote:
If offline tools works for you try './mysqlshow.exe
On Fri, Feb 06, 2004 at 09:17:32AM -0500, Dan Greene wrote:
I'm not 100% sure on this, but what about the .myd file timestamp?
Well, it depends on which table type, obvously. There are several
files for each database, see what the mtime is on each of them, to
determine what's a live file.
If
On 06-Feb-2004 Phil wrote:
Thanks. But I would have thought that such information would have
been
kept automatically somewhere by the server, and it's just a case of
how
to get at it. I have quite a few tables in each database so I don't
really want to have to maintain a timestamp on each
Doesn't seem to change the mtime on table files. It appears that for
InnoDB tables these files are only updated when the definition of a
table is changed. The content of the all InnoDB tables is kept in one or
two massive files directly under the 'data' directory!
On Fri, 2004-02-06 at 18:13,
:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 9:41 PM
To: [EMAIL PROTECTED]
Subject: Last Modified function?
Hi.
I was wondering if there was a way to find out when the last time the
database was modified? (like a last modified function for a webpage?).
Thanks for the help.
Regards,
Camilo
Hi.
I was wondering if there was a way to find out when the last time the
database was modified? (like a last modified function for a webpage?).
Thanks for the help.
Regards,
Camilo Rostoker
--
+=+
Camilo Rostoker
[EMAIL PROTECTED]
http
32 matches
Mail list logo