Parameters   Output Objects  

Searches MySQL data.

Syntax

Select-MySQL [parameters]

Remarks

The Select-MySQL cmdlet allows you to use a syntax similar to SQL SELECT statements to search MySQL data.

$conn = Connect-MySQL -User 'myUser' -Password 'myPassword' -Database 'NorthWind' -Server 'myServer' -Port 3306
Select-MySQL -Connection $conn -Table "`sakila`.Orders" -Columns @("ShipName","ShipCity") -Where "ShipCountry='USA'"