.net - Powershell MySQL Delete return exception

Question

Powershell MySQL Delete return exception

Hi,

I have a script written in Powershell that delete row from a table every night (base on a scheduled task). I always received an exception saying :

Write-MySQLQuery : DELETE FROM AZS_Orphaned_NIC WHERE Present ='0' At C:script.ps1:363 char:1 Write-MySQLQuery $DBconnect $delNIC CategoryInfo : NotSpecified: (:) [Write-Error], Exception FullyQualifiedErrorId : System.Exception,Write-MySQLQuery Write-MySQLQuery : DELETE FROM table WHERE Present ='0'

I don't understand what wrong with the query. How can I have more information about the error ?

Here is the code :

function Connect-MySQL([string]$user, [string]$pass, [string]$MySQLHost, [int]$MySQLPort, [string]$MYSQLDatabase) {
    [void][system.reflection.Assembly]::LoadWithPartialName("MySql.Data")
    $connStr = "server=" + $MySQLHost + ";port=" + $MySQLPort + ";uid=" + $user + ";pwd=" + $pass + ";database=" + $MYSQLDatabase + ";Pooling=FALSE;Allow Zero Datetime=true;Connect Timeout=60"
    $conn = New-Object MySql.Data.MySqlClient.MySqlConnection($connStr)
    $conn.Open()
    $cmd = New-Object MySql.Data.MySqlClient.MySqlCommand("USE $database", $conn)
    return $conn
 
}

function Write-MySQLQuery($conn, [string]$query) {  
    Try { 
        $command = $conn.CreateCommand()
        $command.CommandText = $query
        $RowsInserted = $command.ExecuteNonQuery()
        $command.Dispose()
        if ($RowsInserted) {
            return $true
        }
        else {
            Write-Error -Exception $query
            return $false
        }
    }
    Catch {
        Write-Error -Exception $_.Exception
        return $false
    }
}

$delNIC = "DELETE FROM table WHERE Present ='0'"
Write-MySQLQuery $DBconnect $delNIC 

Thanks for your help

Answer 1

等待大神答复