I looked at the MySQL manual and it tells you how to do automatic timestamps in TIMESTAMP columns. I can do that fine if I use INSERT or UPDATE statements from MySQL monitor. However, LOAD DATA INFILE delivers zeros in the TIMESTAMP column. What am I overlooking?
How can I avoid getting the string of zeros that shows up in my TIMESTAMP column when I use the LOAD DATA INFILE command? To clarify: I have three columns in my table: Column1, Column2, Column3. Column3 is my TIMESTAMP column. I've tried to put the contents of the text file that I'm using for my LOAD DATA INFILE operation as: value1, value2, null and I have also tried leaving out any value for Column3 (the Timestamp column) as so: value1, value2 Either way, I get all zeros for my TIMESTAMP column. My LOAD DATA INFILE line reads as follows: load data infile "/home/mike/data.txt" into table my_table fields terminated by "," enclosed by "\""; __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
