[pLog-svn] r5440 - plog/trunk/install

[Oscar Renalias]

And by the way is this syntax compatible with MySQL 4? I mean the "on
update CURRENT_TIMESTAMP" bit...

On 5/24/07, Jon Daley <plogworld at jon.limedaley.com> wrote:
>         I'd be in favor of killing this.  It hasn't gotten me in a long
> time, but it is a pain if you don't remember to set date=date in your sql
> query.  It makes sense for the modification_date, and maybe now that we
> are using it, we could put it just for that column.
>
> On Thu, 24 May 2007, Ahmad Saleh wrote:
>
> > why you are update the date field to be CURRENT_TIMESTAMP on each update
> > operation on
> > lt_articles table?
> >
> > CREATE TABLE `lt_articles` (
> > `id` int(10) unsigned NOT NULL auto_increment,
> > `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update
> > CURRENT_TIMESTAMP, ...
> >
> > Regards,
> >    Ahmad
> >
>
> --
> Jon Daley
> http://jon.limedaley.com/
>
> Don't take life too seriously that you lose the value of it.
> -- Dr. Richard Farmer
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>