re: zeros in TIMESTAMP column when using LOAD DATA INFILE

2002-12-04 Thread Victoria Reznichenko
miked2miked, Wednesday, December 04, 2002, 8:18:04 AM, you wrote: myc> I looked at the MySQL manual and it tells you how to myc> do automatic timestamps in TIMESTAMP columns. I can myc> do that fine if I use INSERT or UPDATE statements from myc> MySQL monitor. However, LOAD DATA INFILE delivers

zeros in TIMESTAMP column when using LOAD DATA INFILE

2002-12-04 Thread [EMAIL PROTECTED]
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 str