Does anyone know the best way to learn how to use mysql in c++? I searched on google and found a couple api's, but I couldn't really find anything about the api's. I've never used my own MySql server, but for this project I will want to. So if anyone knows of a good place to get started learning how to set up your own MySql server and how to use MySql in c++ could you please let me know. Thank you for your time.

This site:

CLICK

may be of help to you.

Isn't that more based on using MySql with php for a web browser? I already know how to do that, I need to lean how to use it in c++ and how to set up the server. If there is a place on that website I have already been there before and didn't see anything like that. Where exactly would I find something like that on that website.

If anyone else has a link or any helpful information please post.

Thank you for your time.

I got MySql installed and working. I can't figure out how to use mysql++. I found a download for it but when I unzipped it I think something went wrong. It wasn't anything like the manuel said. Did I maybe download the wrong thing or something? Does anyone know anything useful about mysql++?

Ok now I am kind of confused. I went to MySql's forum to see if anyone had already posted something like this and I found a thread. The reply to the wuestion was this:

Quote:Hi.

Try with Dev-Cpp

download pexports-043 (search in google) I don't know the site.

... and execute ...

1. pexports libmysql.dll > libmysql.def
2. dlltool comes with dev-cpp
dlltool -k --input-def libmysql.def --dll-name libmysql.dll --output-lib libmysql.a
3. create a project (with a source code), in project menu->project options->parameters->linker-> add -lmysql
4. compile and link your program
5. a error ocorred

a unrecognized ... mysql_init@4

or something like this.
6. edit limysql.def and add @number in front of the function. Example:
a unrecognized ... mysql_init@4
in libmysql.def
(you find like this)
...
...
mysql_init
...
...
(so)
...
...
mysql_init@4
...
...

save the file. execute dlltool again, and try compile/link,


Bye

This was convenient since I'm using dev-cpp. However I don't know how to use pexports or dlltool. Anyways the part that really has me confused is this is saying that you don't need mysql++ or mysqlapi and you can just use libmysql.dll. Is this true? I mean what exactly do I need mysql++ or mysqlapi for, if you can just use libmysql.dll?

Anyways I read the makefile.mingw and it really didn't explain how to use it. I don't even really know what I'm trying to do with this whole thing. Just from reading the file it seems like its creating a dll, but I thought it was suppose to come with a dll.

If the makefile is even suppose to be making a dll I don't know where I'll find out how to use the dll its making. And if it comes with a dll I didn't find it anywhere in the file and I still don't know how to use that dll either.

So I'd really appreciate it if someone could tell me why I need the mysql++ or mysqlapi when some people say I can use the libmysql.dll, what I do with the makefile.mingw if I need to use mysql++, and what I do after I the makefile.mingw? I know I'm asking for a lot, but I wouldn't be asking if I hadn't looked all over the place and found nothing. Thank you for your time so far.

hmm. Thats kind of exactly what my problem was from the start. I thought you meant that I needed a wraper to use MySql, so I went to download that. I found those instructions for how to get it to work with dev-cpp but I don't know how to use the pexports or the dlltool. If you know naything about either fo those I'd appreciate if you could tell me about them. Thank you for the help so far.

Sorry for the double post but I figured out how to make libmysql.a and I linked that and everything worked fine. But I still don't know how to use any of the MySql commands from within c++. Is that what I need the wrapper for? If I still need the wrapper, can anyone say what I have to do to use the make.mingw? Thank you for your time.