I've created a test table with two columns. The first one is a varchar type for inputting first names. The second column is datetime. The table will eventually expand to include a timestamp column, so I am not interested in getting that to work at this time.
If I use MySQL monitor, I can use the now() function to insert the current date/time into the datetime column. When using load data infile, only the varchar column shows a value, but the datetime column shows a string of zeros. I don't understand why using MySQL monitor works for now() function, but I can't reproduce this when using load data infile. The syntax for my load data infile statement is as follows: load data infile "/home/test/mysql_test.txt" into table Test fields terminated by "," enclosed by "\"" lines terminated by ‘\n’; The contents of my text file (mysql_test.txt) are as follows: firstName, now() Any advice on what I'm overlooking? I searched through the MySQL manual for date datatypes, and couldn't find an answer to my problem. Thank you. __________________________________________________ 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
