I've defined a table, and the last column is a timestamp type.
+-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | UNI | NULL | auto_increment | | dataType | varchar(64) | | PRI | | | | description | tinytext | YES | | NULL | | | dbName | tinytext | YES | | NULL | | | directory | tinytext | YES | | NULL | | | updated | timestamp(14) | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+
I'm using load data to parse local CSV files. All of the columns are being properly parsed and inserted into the tables, however, the timestamp column is always all zeros (0000000).
I don't have a column in the CSV file that maps to the timestamp column (didn't think I needed it based on the documentation).
An insert off the command line with a standard insert works fine, timestamp has the proper value in it.
Any suggestions?
Thanks, Mark
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
