Comments on: Powershell: Run MySQL Querys with Powershell

By: Kei

Kei — Wed, 13 Apr 2022 18:05:17 +0000

Thank you for your posting, this works great locally. I am just wondering if the script still works for a remote server such as mywebsite.com. I am getting an error when I enter my remote server name instead of ‘localhost ‘ and not sure if this is a firewall issue or something else.

By: Thomas Maurer

Thomas Maurer — Sat, 07 Nov 2020 11:55:25 +0000

In reply to DataTraveler1. you're welcome, happy it still helps people :)

By: DataTraveler1

DataTraveler1 — Sat, 07 Nov 2020 05:23:36 +0000

Thanks a lot for posting this even though it was many years ago. :)

By: Stephen Wilson

Stephen Wilson — Wed, 10 Feb 2016 11:18:50 +0000

Thank you!

By: Neale

Neale — Mon, 28 Dec 2015 21:52:31 +0000

change the line: $dataSet.Tables[“data”] | Format-Table
to –> return $dataSet.Tables[“data”]
then the answer set is returned as a system.array object…

By: John

John — Thu, 03 Sep 2015 07:29:49 +0000

Hi,
Awesome script and I have this working but I am unable to get the
‘SELECT last_insert_id()’

working so that I can return id of the row I just inserted. I need this so that I can insert this into other tables for references.

When I run an insert command the insert works. But when I try and grab the last inserted row it returns ‘System.Data.DataRow’

./Mysql.ps1 -Query “insert into foo (blah,blah,blah2) values (‘$one’,’$two’,’$three”)”

$id = ./Mysql.ps1 -Query “SELECT last_insert_id()”

Have you any idea how I can get the values of the last id?

By: Michael

Michael — Fri, 28 Nov 2014 20:26:03 +0000

Very helpful post.
I’m building script in PS with Active Directory output and INSERT info MySQL Table row by row.
Can you help me with this? I already did the AD output but can’t connect to MySQL DB to make the INSERT.

By: Chris

Chris — Thu, 24 Oct 2013 13:12:19 +0000

Hey,

thx for the Script! This is the first one how worked at the firsttime without any errors!

thx

cheers

Chris