powershe执行mysql语句

# 假设 MySQL 已经安装在本地，并且用户名为 'root'，密码为 'password'
mysql -u root -p password -e "SELECT * FROM database_name.table_name;"

# 定义数据库连接参数
$server = "localhost"
$username = "root"
$password = "password"
$database = "database_name"

# 构建连接字符串
$connectionString = "Server=$server;Database=$database;Uid=$username;Pwd=$password;"

# 使用 System.Data.SqlClient 连接 MySQL
$connection = New-Object System.Data.SqlClient.SqlConnection
$connection.ConnectionString = $connectionString

try {
    # 打开连接
    $connection.Open()

    # 创建 SQL 命令
    $command = New-Object System.Data.SqlClient.SqlCommand
    $command.Connection = $connection
    $command.CommandText = "SELECT * FROM table_name;"

    # 执行命令并获取结果
    $reader = $command.ExecuteReader()

    # 处理结果
    while ($reader.Read()) {
        Write-Host "Column1: $($reader[0]), Column2: $($reader[1])"
    }
} catch {
    Write-Host "Error: $_"
} finally {
    # 关闭连接
    $connection.Close()
}