[void][system.reflection.Assembly]::LoadWithPartialName("MySql.Data")
$dbusername = 'root'
$dbpassword = '123456'
$dbname = 'test'
$MySQLHost = 'localhost'
$csvfile = 'C:\Temp\1\'
$Files = Get-ChildItem $csvfile -Recurse -File
$DestinationPath = 'C:\Temp\2\'
$connStr ="server=localhost;database=" + $dbname + ";Persist Security Info=false;user id=" + $dbusername + ";pwd=" + $dbpassword + ";"
$conn = New-Object MySql.Data.MySqlClient.MySqlConnection($connStr)
$conn.Open()
ForEach($File in $Files) {
Write-Host "Read and Convert $($File.Name)" -ForegroundColor Cyan
Get-Content $File.FullName | Set-Content -Encoding $Encoding ($DestinationPath + $File.Name) -Force -Confirm:$false
$cmd.CommandText = "LOAD DATA LOCAL INFILE '"$csvfile + $File.Name"' INTO TABLE `test`.`csv` FIELDS ENCLOSED BY '"' TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES;"
$cmd.ExecuteNonQuery()
}
$conn.Close()$cmd.CommandText = "LOAD DATA LOCAL INFILE '"$csvfile + $File.Name"' INTO TABLE `test`.`csv` FIELDS ENCLOSED BY '"' TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES;"$cmd.CommandText = "LOAD DATA LOCAL INFILE '"$csvfile + $File.Name"' INTO TABLE `test`.`csv` FIELDS ENCLOSED BY '"' TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES;"$cmd.CommandText = "LOAD DATA LOCAL INFILE '" + $csvfile + $File.Name + "' INTO TABLE `test`.`csv` FIELDS ENCLOSED BY '\"' TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES;"
