General discussion
August 20, 2003 at 01:20 PM
richshapiro

MYSQL Question on Load Data

by richshapiro . Updated 23 years, 1 month ago

I’m trying to do a load data infile statement and it works fine except for the timestamp column will not automatically update with the time the row was created it is set to zero’s. On the website it says “TIMESTAMP columns are only set to the current date and time if there is a NULL value for the column (that is, \N), or (for the first TIMESTAMP column only) if the TIMESTAMP column is omitted from the field list when a field list is specified. ” I’m thinking that the second part of this is saying if I do not submit anything in the TIMSTAMP column it will put in the time. This is not working for me. Any ideas

This discussion is locked

All Comments