Discussion Locked

MYSQL Question on Load Data

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

1 reply

by berkimdgkr

I don't think default coulumn value is null when you insert new data. Check the default value for the column.

This discussion is closed to new replies.