참고 : http://markalexanderbain.suite101.com/connecting-to-mysql-from-powershell-a117797
Getting Started with Powerscript and the MySQL .NET
Connector
1. Download Connector .net
예제에서는 원격에서 로긴시도...
2. example.ps1
[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$connectionString = "server=XXXX;uid=XXX;pwd=XXXX;database=XXXX;"
$connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$connection.ConnectionString = $connectionString
$connection.Open()
$sql = "select * from TABLE_NAME where UnixTimeStamp='1336683600'"
$command = New-Object MySql.Data.MySqlClient.MySqlCommand($sql, $connection)
$dataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($command)
$dataSet = New-Object System.Data.DataSet
$recordCount = $dataAdapter.Fill($dataSet, "sample_data")
$dataSet.Tables["sample_data"]
$connection.Close()
3. 실행결과
