Free C/C++ IDE & compiler to create command line Mysql access program

Question

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 shell(), 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.

Answer 1

I think the Eclipse IDE has a MySQL connector. Here is an explanation on how to install it in Eclipse.

Eclipse also supports C/C++ software development - with the Eclipse CDT (C/C++ Development Toolkit), and is one of the most prominent free software IDEs. It's not perfect - and certainly not as polished for C/C++ use as it is for Java - but I use it extensively. You can absolutely use it to write command-line applications, specifically ones which send queries to DBMSes and write CSV output.

The only unknown is whether the MySQL connector for Eclipse can interact, or even coexist, with CDT. That you'll have to check for yourself since I don't use MySQL nor its connector with Eclipse.

I will add, though, that even without the connector component, you should still not have a problem writing your program using Eclipse as an IDE.

Answer 2

SELECT 
    orderNumber, status, orderDate, requiredDate, comments
FROM
    orders
WHERE
    status = 'Cancelled' 
INTO OUTFILE 'C:/tmp/cancelled_orders.csv' 
FIELDS ENCLOSED BY '"' 
TERMINATED BY ';' 
ESCAPED BY '"' 
LINES TERMINATED BY '\r\n';

Done, no IDE, no compiling.

Command line save above into blah.txt

The 2 p's together are intentional so you can enter the password from the command line also.

mysql -u root -ppassword databaseName

Answer 3

How about built-in stored procedure:

http://blog.secaserver.com/2014/10/mysql-export-table-split-csv-stored-procedure/

https://stackoverflow.com/questions/11039324/stored-procedure-that-exports-data-into-csv-files-only-exports-to-one-file

Ripped from above stack overflow:

DECLARE 
   @StartDT DATE, 
   @TableName NVARCHAR(50), 
   @FileLocation VARCHAR(255);

SET @TableName = N'ViewAccountDetail';

SELECT @StartDT = DATEADD(MONTH, DATEDIFF(MONTH, '19000101', MIN(dos)), '19000101')
   FROM dbo.accn_demographics;

   PRINT @StartDT;
-- ^^^^^ debugging 101 - what month do we think we're starting at?

WHILE @StartDT < '20110901'
BEGIN
    SET @FileLocation = 'C:\test\' + @TableName
      + CONVERT(CHAR(10), @StartDT, 120) + '.csv';

      PRINT @FileLocation;
    --^^^^^ again, debugging 101 - what does the filename currently look like?

    --EXEC BCP_Text_File @TableName, @FileLocation    
    SET @StartDT = DATEADD(MONTH, 1, @StartDT);
END

No compiling,no IDE, and now with no external files per user request.