Joseph's suggestion works beautifully when I do an
insert statement from the MySQL monitor. Now how can
I avoid getting the string of zeros that shows up when
I use the LOAD DATA INFILE command?
To clarify:
I have three columns in my table: Column1, Column2,
Column3. Column3 is my TIMESTAMP col
According to the manual, 'timestamp' does exactly what you are asking
for:
"The TIMESTAMP column type provides a type that you can use to
automatically mark INSERT or UPDATE operations with the current date and
time. If you have multiple TIMESTAMP columns, only the first one is
updated automatical
I've created a table that contains a column called
"recordLastModified" and that column uses "timestamp"
as the data type. Is there a way in MySQL to
automatically update timestamp fields as records are
modified? I want it to be nearly automatic in the
same way that using "auto_increment" increas
