mysql - 使用 MYSQL 查询的 powershell foreach 循环

Question

我正在尝试从 Mysql 中提取一个查询，并从该查询的每个条目中获取一个循环。

这是 MySQL 查询:

从 ad_test_table 中选择 ad_groups，其中 ad_names = 'test'

返回

测试1，测试2，测试3

现在我想为每个条目 ad_group 执行一个 for 循环，但它不会循环每个由逗号分隔的条目

foreach ($group in $AD_query){
    write-host "group : " $group
}

只循环一次并给出test1,test2,test3

这是完整的代码。是数据库中输入的数据不正确还是我在代码中遗漏了某些内容？

function mysql_query($query)
{
  $MySQLAdminUserName = 'AD_user'
  $MySQLAdminPassword = 'AD_password'
  $MySQLDatabase = 'User_creation'
  $MySQLHost = 'AD_MySQL_server'
  $ConnectionString = "server=" + $MySQLHost + ";port=3306;uid=" + 
  $MySQLAdminUserName + ";pwd=" + $MySQLAdminPassword + ";database="+$MySQLDatabase
  Try {
    [void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
    $Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
    $Connection.ConnectionString = $ConnectionString
    $Connection.Open()
    $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
    $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
    $DataSet = New-Object System.Data.DataSet
    $RecordCount = $dataAdapter.Fill($dataSet, "data")
    $DataSet.Tables[0]
  }
  Catch {
    Write-Host "ERROR : Unable to run query : $query `n$Error[0]"
  }
  Finally {
    $Connection.Close()
  }
}




#$Full_AD_rights_list_query_full = New-Object System.Collections.ArrayList

$AD_query = New-Object System.Collections.ArrayList
$AD_query = mysql_query "SELECT ad_groups FROM ad_test_table where ad_names = 'test'"


foreach ($group in $AD_query.item(0)) {
  write-host ""
  write-host "group : " $group
}

Answer 1

mysql_query 返回一个数据表。您的结果是一个数据表(不是 aSystem.Collections.ArrayList 因为覆盖)。试试这个:

foreach ($Row in $AD_query.Rows)
{ 
  "value is : {0}" -f $Row["ad_groups"]
}