Powershell -将SQLite表导出到csv

# 导入SQLite模块
Add-Type -Path "System.Data.SQLite.dll"

# 连接到SQLite数据库
$connectionString = "Data Source=C:\path\to\database.db"
$connection = New-Object System.Data.SQLite.SQLiteConnection($connectionString)
$connection.Open()

# 执行查询语句
$query = "SELECT * FROM table_name"
$command = New-Object System.Data.SQLite.SQLiteCommand($query, $connection)
$adapter = New-Object System.Data.SQLite.SQLiteDataAdapter($command)
$dataTable = New-Object System.Data.DataTable
$adapter.Fill($dataTable)

# 导出数据到csv文件
$dataTable | Export-Csv -Path "C:\path\to\output.csv" -NoTypeInformation

# 关闭连接
$connection.Close()