tags:

views:

42

answers:

1
+2  Q: 

How to MySQL Trigger to update a field whenever any record is touched?

I haver zero experience with triggers in MySQL. Learnt them in school (Oracle environment).

I have a table which already has a datestamp column for insert date.

I want to update a Record_Touched field whenever any record is touched in this table. What is the best efficient way of doing it?

Thank you...

+2  A: 

Create that field as a TimeStamp and set ON UPDATE CURRENT_TIMESTAMP

As described, I do not believe that you need a Trigger.

Gary  2010-06-11 15:37:47
+1: Use the DEFAULT constraint for the desired behavior: http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
OMG Ponies  2010-06-11 15:54:57
I already have another column with on update current_timestamp.I want another field and MySQL allows only one such update I believe. Thanks ...
ThinkCode  2010-06-11 16:00:07
@ThinkCode: There's no limit to the number of columns with DEFAULT constraints.
OMG Ponies  2010-06-11 16:14:55

related questions

Handling and storing elapsed time
How do I convert local time to UTC in Python?
Mono's DateTime Serialization
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Parsing exact dates in C# shouldn't force you to create an IFormatProvider
C# Casting vs. Parse
.NET Date Const (with Globalization)
Dynamic regex for date time formats
What is the simplest way to find the difference between 2 times in python?
Best way to convert DateTime to "n Hours Ago" in SQL
What's a good way to overwrite DateTime.Now during testing?
Datetime arithmetic with a string in Ruby
How can I get the DateTime for the Start of the Week?
Is DateTime.Now the best way to measure a function's performance?
SQL Server DateTime conversion failure
Natural language date/time parser for .NET?
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Why does this python date/time conversion seem wrong?
Dealing with PHP server and MySQL server in different time zones
How do I parse and convert DateTime's to the RFC 3339 date-time format?
HOWTO - Compare a date string to datetime in SQL Server?
Best method for varchar date validation in Sybase (T-SQL)?
What's the BEST way to remove the time portion of a datetime value (SQL Server)
How do I calculate relative time?
How do I calculate someone's age in C#?