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
I just need to the proper update query syntax of mysql using powershell script — Sandeep

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

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

run mysql update query using powershell script

2 Answers