[no subject]

On Tue, 2005-05-31 at 15:11, James Sumners wrote:
&gt; <a  rel="nofollow" href="http://dev.mysql.com/doc/mysql/en/datetime.html";>http://dev.mysql.com/doc/mysql/en/datetime.html</a>
&gt; 
&gt; On 31 May 2005 15:03:52 -0400, Christopher Fowler
&gt; &lt;cfowler at outpostsentinel.com&gt; wrote:
&gt; &gt; I'm running MySQL 4.X and I want to be able to see when rows are
&gt; &gt; modified.  Is there a way to create a modified column in a table that
&gt; &gt; gets updated with now() everytime a UPDATE or INSERT is executed?
&gt; &gt; 
&gt; &gt; I had a case where I needed to know when a table was changed to see if a
&gt; &gt; data change had caused a program to act strangely.
&gt; &gt; 
&gt; &gt; 
&gt; &gt; 
&gt; &gt; _______________________________________________
&gt; &gt; Ale mailing list
&gt; &gt; Ale at ale.org
&gt; &gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; &gt; 
&gt; 


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="01100" href="msg01100.html">[ale] MySQL and changes</a></strong>
<ul><li><em>From:</em> esoteric at 3times25.net (Geoffrey)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="01088" href="msg01088.html">[ale] MySQL and changes</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
<li><strong><a name="01092" href="msg01092.html">[ale] MySQL and changes</a></strong>
<ul><li><em>From:</em> james.sumners at gmail.com (James Sumners)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg01089.html">[ale] MySQL and changes</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg01091.html">[ale] MySQL and changes</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg01092.html">[ale] MySQL and changes</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg01100.html">[ale] MySQL and changes</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#01090"><strong>Date</strong></a></li>
<li><a href="threads.html#01090"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>