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]