mySQL with C++ Visual Studio 2002

[porto99]

Does anyone know of any good introductions/tutorials, i.e. sample projects using mySQL with an MFC C++ Visual Studio .Net 2002 program.

I was generating my own database, just a large array of type myStruct and initialing it at startup via a Tab delimited file.

I would like to populate the mySQL database with this Tab delimited file is that possible?

Note the reason for moving to mySQL is one of speed and I was just using the CStringArray class to store the names in items and do all the searching; e.g. string searches and the array was getting quite large.

Note I have just unstalled mySQL 4.1 onto my PC (runs a dos window), and I have just started reading the syntax & commands for SQL. So any information most welcome.

 

[Kalisto]

There are some simple programs with the mysql api's that show you how to access via c++. You can access directly, but I found the MySQL libs in the api's easy to use, and saved time learning / writing loads of code.

The hardest bit ends up creating the MySQL query strings, in C++, making sure you have all the correct ()'" in the correct places, but if you know what all your data will be, adn you are not doing a great deal of adding / updating it shouldnt be dificult.

K

 

[porto99]

Still struggling to find instructions on what to download and how to build the C++ API library for VS 2002.

I downloaded a .TAR file but what do I do with it?!?

I have had a play with the mySQL 4.1 database and quite happy with that, its just how to download, and setup the mySQL++ API.

Help!