C and MySql

I am working in C and I wanna connect my app in C with MySql.
Is there a app library to use with C to connect for mysql?
I had the library for mysql++ but this work more properly with c++ and I am using C?
Any comments?
TIA

try this

URL

take it from me.....mysql and c are a pain in the ***. there is an api for mysql, though, but there are a few things you might want to know:

/*all this applies to unix*/

to compile, type this:

gcc -g -o -L/*directory*/lib -I/*directory*/include -lmysqlclient -lm

where I put *directory*, put the location of your mysql folder. This should be something like /usr/local/mysql/

then....here are some code snippets you can use:


/*connect to mysql*/
mysql_init(&mysql);
connection = mysql_connect(&mysql, "localhost", "9841860u", "9841860u");

/*check for a connection error*/
if(connection == NULL)
{
/*print error message*/
printf(mysql_error(&mysql));
}


/*select a database*/
mysql_select_db(&mysql, "Nag");

/*here you create a string to pass as a query...you have to do it this way (I think) because you can't pass mysql a variable from C*/
strcpy(query, "SELECT column FROM table WHERE variable = ");
strcat(query, x);
state = mysql_query(connection, query);
if(state != 0)
{
printf(mysql_error(connection));
}

/*this will give you a result set (if you are expecting a result)...you can go through that with row=mysql_fetch_row(result)*/

/*before you can call another query that will return a result set, you must free the result set*/
mysql_free_result(result);

/*close the mysql connection*/
mysql_close(connection);

there are a whole load of functions and structures used, just go through the c api section of the mysql manual.....you can get that online

hope I was of help,

good luck,

Des.

how about windows?
how to compile them with bcc?
thx

sorry, fate and the universe have conspired to ensure I don't speak windows.

god...~
too bad
thx anyway :-)

any others know how to do that?