I just need to code a short command line program to run a
SELECT and convert the result to CSV, so am open to any free IDE/Compiler solution for Windows 10.
I tried MS Visual Studio and the official Mysql connector, but from the menu Tools/Connect to database, I only see options for MS & Oracle, nothing for MySql.
So, I guess I am looking for something else?
[Update] Look, guys, I do appreciate that you are trying to help, but please, no more answers with stored procedures or the like.
I must be able to connect to a MySql database and execute arbitrary commands (plus a whole lot more non-Mysql functionality) from C++.
Please also note, that I do not want to drive Mysql through the c
popen() or similar function, as if from the command line. I need to use a database connector from C++.
Can we please stick with recommending an IDE which will make that easy? Thanks.