Importing External Table in Studio 2020
Posted: Fri 12 Feb 2021 18:09
Hello,
We are trying to import the local csv file into the MySQL table using the Import External Data command....it is able to import the individual csv file and save the batch file - but how do I make the batch file import the updated csv file into the same table without going through all the steps - i.e. NOT creating the detailed sql script for each new fresh data in the same csv file???? we need to be constantly updating the remote table with the constantly recalculated csv file automatically (same file structure, same file name just new numbers) - ideally by simply running a BATCH file - ideal for external automators like Network Automation Automate...
We are trying to import the local csv file into the MySQL table using the Import External Data command....it is able to import the individual csv file and save the batch file - but how do I make the batch file import the updated csv file into the same table without going through all the steps - i.e. NOT creating the detailed sql script for each new fresh data in the same csv file???? we need to be constantly updating the remote table with the constantly recalculated csv file automatically (same file structure, same file name just new numbers) - ideally by simply running a BATCH file - ideal for external automators like Network Automation Automate...