Parameters   Output Objects  

Searches SingleStore data.

Syntax

Select-SingleStore [parameters]

Remarks

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

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