mySQL query

Python

apt install python3-mysql.connector

import mysql.connector
mydb = mysql.connector.connect(
  host ="localhost",
  user ="juzer",
  password="admin123",
  database="probnabaza"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM probnatablica "
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
  print (x)

Powershell

http://dev.mysql.com/downloads/connector/net/

Add-Type –Path 'C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.27\Assemblies\net5.0\MySql.Data.dll'
$Connection = [MySql.Data.MySqlClient.MySqlConnection]@{ConnectionString="server=localhost;uid=juzer;pwd=admin123;database=probnabaza"}
$Connection.Open()
$sql = New-Object MySql.Data.MySqlClient.MySqlCommand
$MYSQLDataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter
$MYSQLDataSet = New-Object System.Data.DataSet
$sql.Connection = $Connection
$sql.CommandText = "SELECT * FROM probnatablica"
$MYSQLDataAdapter.SelectCommand=$sql
$MYSQLDataAdapter.Fill($MYSQLDataSet, "Podatki") | Out-Null
# Write-Host $MYSQLDataSet.tables[0].errortxt
$global:Tablica = Foreach ($DataSet in $MYSQLDataSet.tables[0])
{
  Write-Host "ID:" $DataSet.id "... Naziv:" $DataSet.naziv "... Opis:" $DataSet.opis
}
$Connection.Close()
image_pdfimage_print