Re: alternative to triggers for mysql?
- From: "E.J. Zufelt" <lists@xxxxxxxxx>
- To: programmingblind@xxxxxxxxxxxxx
- Date: Thu, 16 Jun 2011 21:56:36 -0400
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
> //www.freelists.org/list/programmingblind
>
Other related posts:
