On 15 Apr 2002, at 15:34, Carl McNamee wrote: > We are attempting to put records into a table using the "load data" or > mysqlimport commands. One quirk is with columns that include a timestamp > type. When we import the records we get zeros in the timestamp column. How > can we get the current time inserted when using the "load data" or > mysqlimport commands?
It sounds like you're using empty fields in your text file for the timestamps. But to insert nulls (which is what's needed for timestamps), you need to represent them in the text file as \N, not the empty string (which is interpreted as 0 for numeric or date fields). -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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
