I have 300+ flat files. I am importing/loading them using
LOAD DATA LOCAL INFILE 'D:\\MxxT\tot2098.TXT' INTO TABLE Twenty.F98 FIELDS TERMINATED BY '' lines terminated by '\r\n' ;
on my MySQL Server database.
Each of 20 files makes 28 tables. I have a flag variable which is MachineType in all flat files. After import of 20 files. I have to do
SET SQL_SAFE_UPDATES=0; DELETE FROM Twenty.F98 WHERE MachineType <>1; SELECT DISTINCT MachineType FROM Twenty.F98;
Is there any way I can place a condition when loading data file?
In MS Access I have used
Schema.iniwhich loads the files in a second or less. Is there such mechanism available for MySQL?
I have to create a dashboard after loading of all files. I am thinking of Using Excel as front end. Is there anything else better than that?