Re: Issue with timestamp columns while working with MySQL load data in file

2015-04-13 Thread hsv
On 2015/04/12 08:52, Pothanaboyina Trimurthy wrote: The problem is , as mentioned the load data is taking around 2 hours, I have 2 timestamp columns for one column I am passing the input through load data, and for the column "DB_MODIFIED_DATETIME" no input is provided, At the end of the load data

Issue with timestamp columns while working with MySQL load data in file

2015-04-12 Thread Pothanaboyina Trimurthy
Hi All, I am facing an issue with timestamp columns while working with MySQL load data in file, I am loading around a million records which is taking around 2 hours to complete the load data. Before get into more details about the problem, first let me share the table structure. CREATE TABLE