Re: alternative to triggers for mysql?

Have created and updated columns in the table and pass in the timestamp with 
the rest of the insert or update query.


Everett Zufelt
http://zufelt.ca

Follow me on Twitter
http://twitter.com/ezufelt

View my LinkedIn Profile
http://www.linkedin.com/in/ezufelt



On 2011-06-16, at 9:51 PM, Alex Hall wrote:

> Hi all,
> I have just found out that bluehost.com does not support triggers
> since one needs superuser privileges for that. Two of the tables I use
> keep records, and I was using triggers to track the date and time that
> a given record was first created and then updated. An article, for
> instance, might be created on June 1, 2010 at 1422, then updated a
> month later, then updated again in September. The trigger would have
> stored the date created and the date in September of the most recent
> update. Is there a way to do this without using triggers?
> 
> -- 
> Have a great day,
> Alex (msg sent from GMail website)
> mehgcap@xxxxxxxxx; http://www.facebook.com/mehgcap
> __________
> View the list's information and change your settings at 
> http://www.freelists.org/list/programmingblind
>

Other related posts: