< Back
Invoke-MySqlQuery
Post
NAME Invoke-MySqlQuery
SYNTAX
Invoke-MySqlQuery -SqlQuery <SqlQuery> [-Credential <pscredential>] [-ConnectionTimeout <int>] [-Database
<string>] [-Server <string>] [-ConnectionString <string>] [-NoTrans] [-WhatIf] [-Confirm] [-UseTransaction]
[<CommonParameters>]
Invoke-MySqlQuery -Sql <string> [-Parameters <hashtable>] [-Credential <pscredential>] [-CommandTimeout <int>]
[-ConnectionTimeout <int>] [-Scalar] [-CUD] [-StoredProcedure] [-Database <string>] [-Server <string>]
[-ConnectionString <string>] [-NoTrans] [-ExpectedRowCount <int>] [-Callback <scriptblock>] [-WhatIf] [-Confirm]
[-UseTransaction] [<CommonParameters>]
PARAMETERS
-CUD
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-Callback <scriptblock>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-CommandTimeout <int>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-Confirm
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases cf
Dynamic? false
-ConnectionString <string>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-ConnectionTimeout <int>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-Credential <pscredential>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-Database <string>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-ExpectedRowCount <int>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-NoTrans
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-Parameters <hashtable>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-Scalar
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-Server <string>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-Sql <string>
Required? true
Position? Named
Accept pipeline input? true (ByValue, ByPropertyName)
Parameter set name Default
Aliases None
Dynamic? false
-SqlQuery <SqlQuery>
Use New-SqlQuery to create a SqlQuery object.
Required? true
Position? Named
Accept pipeline input? true (ByValue)
Parameter set name SqlQuery
Aliases None
Dynamic? false
-StoredProcedure
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-UseTransaction
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases usetx
Dynamic? false
-WhatIf
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases wi
Dynamic? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
InvokeQuery.SqlQuery
System.String
OUTPUTS
System.Object
ALIASES
None
REMARKS
None
SYNTAX
Invoke-MySqlQuery -SqlQuery <SqlQuery> [-Credential <pscredential>] [-ConnectionTimeout <int>] [-Database
<string>] [-Server <string>] [-ConnectionString <string>] [-NoTrans] [-WhatIf] [-Confirm] [-UseTransaction]
[<CommonParameters>]
Invoke-MySqlQuery -Sql <string> [-Parameters <hashtable>] [-Credential <pscredential>] [-CommandTimeout <int>]
[-ConnectionTimeout <int>] [-Scalar] [-CUD] [-StoredProcedure] [-Database <string>] [-Server <string>]
[-ConnectionString <string>] [-NoTrans] [-ExpectedRowCount <int>] [-Callback <scriptblock>] [-WhatIf] [-Confirm]
[-UseTransaction] [<CommonParameters>]
PARAMETERS
-CUD
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-Callback <scriptblock>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-CommandTimeout <int>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-Confirm
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases cf
Dynamic? false
-ConnectionString <string>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-ConnectionTimeout <int>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-Credential <pscredential>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-Database <string>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-ExpectedRowCount <int>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-NoTrans
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-Parameters <hashtable>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-Scalar
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-Server <string>
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases None
Dynamic? false
-Sql <string>
Required? true
Position? Named
Accept pipeline input? true (ByValue, ByPropertyName)
Parameter set name Default
Aliases None
Dynamic? false
-SqlQuery <SqlQuery>
Use New-SqlQuery to create a SqlQuery object.
Required? true
Position? Named
Accept pipeline input? true (ByValue)
Parameter set name SqlQuery
Aliases None
Dynamic? false
-StoredProcedure
Required? false
Position? Named
Accept pipeline input? false
Parameter set name Default
Aliases None
Dynamic? false
-UseTransaction
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases usetx
Dynamic? false
-WhatIf
Required? false
Position? Named
Accept pipeline input? false
Parameter set name (All)
Aliases wi
Dynamic? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
InvokeQuery.SqlQuery
System.String
OUTPUTS
System.Object
ALIASES
None
REMARKS
None