Insertar valores en una tabla de una base de datos en MySQL con PowerShell | Scripting and security

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

$Query = 'INSERT INTO Persons (PersonID,LastName,FirstName,Address,City,Estado) VALUES ("1","Grillo","Pepito","Castellana","Berlin","1")'
$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]
$Connection.Close()

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado"

$Connection.ConnectionString = $ConnectionString

$Connection.Open()

$Query = 'INSERT INTO Persons (PersonID,LastName,FirstName,Address,City,Estado) VALUES ("1","Grillo","Pepito","Castellana","Berlin","1")'

$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]

$Connection.Close()

670784971 654514606 609904369 676562939 645930479 631614008 610394435 607106849 697109771 664690462 634037685 647849914 664362545 641297344 614145867 651005435 628674971 644612797 662018021 688097318 675162069 647957063 629696006 637295527 672991134 663332345 657311439 616614208 608635134 632653286 632393422 636524392 697667510 631447899 648168681 618166048 616575826 691868518 682607221 693728461 694228232 600333395 612322000 637825559 674139355 638344693 669671312 632615322 656221864 698397060 661313058 632498055 676380237 676230709 659562010 667709726 668571639 633759509 688845417 667997160 659635480 607087407 653932880 698380810 686992635 652419854 618060037 662724949 673997567 643029580 639897306 642490874 647886023 686801712 607609135 665516563 698231825 604452571 661355702 697873782 621805095 644892243 620455756 661143903 621677147 686513894 616960479 669366753 675033912 632001818 610754225 691150261 651152972 604662283 687128758 694803337 648826268 670673616 637955851 628757088 696221008 697245143 642577100 663026218 627906880 685034951 622128165 612157242 618534987 602456459 672922759 651789313 618461217 639596436 642554009 642635755 671997122 631932012 625710750 657625034 655333388 630417195 677246803 631858753 670349696 691992139 697349324 656433585 695318922 624209834 643811213 668994905 636441598 693792034 692517051 600304822 657210032 639062327 667347016 694954234 632744119 606491897 643603022 666496609 695544314 654956258 687096575 658220516 634880841 678537644

The minimum operating voltage for the memory device in millivolts

How to draw the letter N

Verificar si un comando de Windows se ha ejecutado correctamente desde PowerShell