Re: Automatically updating Timestamp Column with DBD:MYSQL

Paul DuBois <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <p06210256be83623be7fb@[192.168.1.35]>
At 0:00 +0100 4/14/05, zzapper wrote:
>Hi,
>It's late (at least here in my part of the universe) but I'm 
>inserting records into a mysql database
>with Perl DBI DBD:MySQL and was expecting my first & only timestamp 
>field to be updated without me
>needing to specifically mention it in the insert clause, but the 
>field is obstinately remaining null
>
>Any Ideas?

Let's see the table definition.  In recent versions of MySQL,
you can declare a TIMESTAMP such that it _can_ store NULL values,
and such that it doesn't automatically update.

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.