Re: store search result as new table in memory

2015-04-12 Thread Jan Steinman
> From: Lucio Chiappetti > > On Tue, 7 Apr 2015, shawn l.green wrote: > >> The advantage to using temporary tables is that they can have indexes on >> them. You can create the indexes when you create the table or you can ALTER >> the table later to add them. > > if they are big, using proper

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 `te