"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
"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.
> > 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,
> whic
"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,
If all you're looking to do is check the last time the entire table
was updated, why don't you just look at the last time the .frm file
(if using MyISAM tables, of course) was modified?
Thursday, June 10, 2004, 7:19:32 AM, you wrote:
PM> If your table contains a timestamp field, it will upd
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
Se
I know you can set a column in each table that will update itself with the
current ctime every time that row is modified, but I haven't found a per db,
or per table variable yet. (I believe mSQL has something like this, but not
mysql.
---
Jason H. Frisvold
Senior ATM Engi
