Data Import using PowerShell into MySQL database.
When it was asked to work on PowerShell to import data into the MySQL database. It is seen that very less things are written for using MySQL database using PowerShell. So, it was a very big hurdle while starting this assignment. While searching on the internet there are two modules that are majorly used while working on MySQL database using PowerShell. 1. MySQLCmdlets 2. SimpleSQL These two modules make up most of our work for MySQL with PowerShell. For this task now we were having two ways to import CSV files to MySQL tables. 1. Write a program to investigate each row and inset data into the table. 2. Load is one command which is there in MySQL database, which imports CSV files to table. The load command is a very fast way to import CSV file data into a MySQL table. So, we thought to go ahead with this load command. ...