如何在MySQL查询中使用powershell自定义对象变量

# 安装MySQL .NET驱动程序（如果尚未安装）
# Install-Module -Name MySql.Data

# 导入MySQL模块
Import-Module MySql.Data

# 数据库连接配置
$servername = "localhost"
$username = "your_username"
$password = "your_password"
$dbname = "your_database"

# 创建数据库连接
$conn = New-Object MySql.Data.MySqlClient.MySqlConnection
$conn.ConnectionString = "server=$servername;user id=$username;password=$password;database=$dbname"
$conn.Open()

# 执行SQL查询
$sql = "SELECT * FROM your_table"
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($sql, $conn)
$reader = $cmd.ExecuteReader()

# 创建一个空数组来存储自定义对象
$results = @()

# 遍历查询结果并创建自定义对象
while ($reader.Read()) {
    $obj = New-Object PSObject -Property @{
        Column1 = $reader["column1"]
        Column2 = $reader["column2"]
        # 添加更多列...
    }
    $results += $obj
}

# 关闭数据库连接
$conn.Close()

# 输出自定义对象数组
$results