Im trying to upload a FILE into one table. The FILE has all the fields of the table, except for the last field which is the updated time.

For that reason I have created the table with the field:

"nrm_now" TIMESTAMP(0) DEFAULT current_timestamp()

BUT when im trying to insert the FILE (COY INTO test_20170711 from FILE .... ), there is an error:

Failed to import table 'test_20170711', Column value 143 missing

Does anybody can help me? Am I doing something wrong? Which should be the best way to implement this?

Thnks in advance

Ariel