[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ale] MySQL and changes

Subject: [ale] MySQL and changes
From: cfowler at outpostsentinel.com (Christopher Fowler)
Date: Tue May 31 15:14:01 2005

I'm running MySQL 4.X and I want to be able to see when rows are
modified.  Is there a way to create a modified column in a table that
gets updated with now() everytime a UPDATE or INSERT is executed?

I had a case where I needed to know when a table was changed to see if a
data change had caused a program to act strangely.

Follow-Ups:
- [ale] MySQL and changes
  - From: hpassau at emory.edu (Billy Passauer)
- [ale] MySQL and changes
  - From: barry at bytemason.org (Barry Hawkins)
- [ale] MySQL and changes
  - From: james.sumners at gmail.com (James Sumners)

Prev by Date: [ale] OT: Consulting Gig
Next by Date: [ale] MySQL and changes
Previous by thread: [ale] Can anyone help me get the Rox Filer to work with E inSUSE 9.1
Next by thread: [ale] MySQL and changes
Index(es):
- Date
- Thread