RE: Help for Insert statement needed. - indrek siitan - com.mysql.lists.perl

2 messages in com.mysql.lists.perlRE: Help for Insert statement needed.

From	Sent On	Attachments
Sadhanandham Balaraman	16 May 2000 04:12
indrek siitan	16 May 2000 09:53

Subject:	RE: Help for Insert statement needed.
From:	indrek siitan (tf...@mysql.com)
Date:	05/16/2000 09:53:17 AM
List:	com.mysql.lists.perl

Hi,

I am new to mysql DBI. I have two TIMESTAMP(14) fields and I want to Insert values for both fields from mysql DBD. How I do that? Any replies are welcome.

the first timestamp is updated automagically when you insert or update a record. to set the second timestamp to current time, just insert NULL to it.

Rgds, Tfr