run mysql update query using powershell script

Question

I'm trying to run the update query after running the mysql scripts in mysql db using powershell script, below mentioned query i am trying

Invoke-MySqlQuery -Query "UPDATE $DataBase.tablename SET account=$Storageacc,primary_key = $StorageKey,blob_container= $Container WHERE id = 1 and name = 'testing'"

when i run the above query using powershell script iam getting below error

The term 'Invoke-MySqlQuery' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again

even i tried another way as well :- run-MySQLQuery -ConnectionString "$Connectionstring" -Query "UPDATE $DataBase.tablename SET account=$Storageacc,primary_key = $StorageKey,blob_container= $Container WHERE id = 1 and name = 'testing'" still iam getting error ##[error]The term 'run-MySQLQuery' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. — Sandeep
– Sandeep, Commented Nov 1, 2017 at 10:08
I just need to the proper update query syntax of mysql using powershell script — Sandeep
– Sandeep, Commented Nov 1, 2017 at 10:11

Vladimir Bundalo · Accepted Answer · 2017-11-01 10:19:18Z

1

You are missing module or software which is needed to interact with Powershell. Please check this: Querying MySQL Database with Powershell

answered Nov 1, 2017 at 10:19

Vladimir Bundalo

6559 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sandeep Over a year ago

No we have added module..thats why we are able to run the scripts

Vladimir Bundalo Over a year ago

Get-Module -ListAvailable ----- to check if the module is imported. If it is giving you that error message, it means that the cmdlet is not there.

PsCustomObject · Accepted Answer · 2017-11-01 17:14:45Z

0

The error means the module is either not installed/present on your machine or has not been imported into the powershell session.

What does Get-Module display?

answered Nov 1, 2017 at 17:14

PsCustomObject

1253 silver badges9 bronze badges

Collectives™ on Stack Overflow

run mysql update query using powershell script

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related