Skip to navigation

How to update mysql data with a powershell script?07.12.13

Reply

Anonymous

function ConnectMySQL([string]$user,[string]$pass,[string]$MySQLHost,[string]$database) {
  # Load MySQL .NET Connector Objects
  [void][system.reflection.Assembly]::LoadWithPartialName("MySql.Data")
 
  # Open Connection
  $connStr = "server=" + $MySQLHost + ";port=3306;uid=" + $user + ";pwd=" + $pass + ";database="+$database+";Pooling=FALSE"
  $conn = New-Object MySql.Data.MySqlClient.MySqlConnection($connStr)
  $conn.Open()
  $cmd = New-Object MySql.Data.MySqlClient.MySqlCommand("USE $database", $conn)
  return $conn
 }
 
function WriteMySQLQuery($conn, [string]$query) {
  $command = $conn.CreateCommand()
  $command.CommandText = $query
  $RowsInserted = $command.ExecuteNonQuery()
  $command.Dispose()
  if ($RowsInserted) {
    return $RowInserted
  } else {
    return $false
  }
}
 
# setup vars
$user = 'USER'
$pass = 'PASSWORD'
$database = 'MYSQLDBNAME'
$MySQLHost = 'IPADDRESS'
 
# Connect to MySQL Database
$conn = ConnectMySQL $user $pass $MySQLHost $database
 
# Read all the records from table
 $date = date;
 $query = "update NAME set DESCRIPTION ='$date' where ID ='14'"
 $Rows = WriteMySQLQuery $conn $query
 Write-Host $Rows " inserted into database"

07.12.13

http://arodd.com/blog/?q=node/8

Reply

Anonymous