I think the default is to insert the current timestamp on creation of new row and not change that value even if row is updated... ?
I remember I had some fun with phpMyAdmin trying to figure out how they had this set up. -- Kristina > > `edi_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update > > CURRENT_TIMESTAMP, > > Shouldn't it auto update by default? > > alter table <tablename> modify edi_updated timestamp NOT NULL; > > Wouldn't that auto update it anyway? > _______________________________________________ > New York PHP Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php > > _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
