Kevin Weinrich
Kevin Weinrich
With -Stream, I get all 77 records every time. I don't understand the documentation: "If the -Stream switch is used, only the first result set is returned and the output...
So sorry it's taken so long to get back to you on this. I wrote this to create the MySQL table: ``` CREATE TABLE JunctionPointTargets2 ( SERVER VARCHAR(25), SHARE VARCHAR(25),...
Hmmm. I did include the MySQL to create the table, but I'm not very good with markdown. I'll try again here: ``` CREATE TABLE JunctionPointTargets2 ( SERVER VARCHAR(25), SHARE VARCHAR(25),...
Interesting: PowerShell 5.1.22621.2506 returns all "4s". But 7.4.2 returns 4/3/4.
Your code (with no primary key) runs the same with both PS versions, giving the results you expected.
I tried running with -noprofile - no improvement. I have been testing on my Win 11 VM. At your suggestion, I used a Windows 2019 Server VM. No improvement there,...
``` Import-Module SimplySQL -RequiredVersion 2.0.2.70 #Import-Module SimplySQL -RequiredVersion 1.9.1 Invoke-SqlUpdate -Query "CREATE DATABASE IF NOT EXISTS MyTester" Invoke-SqlUpdate -Query "USE MyTester" Invoke-SqlUpdate -Query "DROP TABLE IF EXISTS JunctionPointTargets2" Invoke-SqlUpdate -Query...
Adding fields to the query works, but so does the -Stream option you suggested, so that's the most straightforward for now. Until MySqlConnector stops "optimizing" my query to return what...
Thanks so much for your persistence on this!
That worked great! Thanks for all your help.