Carl,
Monday, April 15, 2002, 11:34:09 PM, you wrote:
CM> We are attempting to put records into a table using the "load data" or
CM> mysqlimport commands. One quirk is with columns that include a timestamp
CM> type. When we import the records we get zeros in the timestamp column. How
CM> can we get the current time inserted when using the "load data" or
CM> mysqlimport commands?
If you get zero values in your TIMESTAMP column it means that you pass
incorrect data to the TIMESTAMP. LOAD DATA INFILE or mysqlimport sets
TIMESTAMP to the current date and time if there is NULL value for the
column or TIMESTAMP column is left out from the field list. Take a
look at:
http://www.mysql.com/doc/L/O/LOAD_DATA.html
http://www.mysql.com/doc/m/y/mysqlimport.html
CM> Carl McNamee
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.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
