<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body bgcolor="#FFFFFF">
Hi Jean Paul,
<p>I just happen to be doing the same thing (using MySQL with KDevelop)
<br>I got the newest version of MySQL from www.mysql.net, version 3.22
<br>I got 3 rpm's, the database, the clients and the development rpm
<br>installed with no problem on RH 6.0
<br>in KDevelop, under "Project/Options/Linker Options" I added "-L/usr/lib/mysgl
-l/mysqlclient"
<br>after this I just "include <mysql/mysql.h>" in the doc class header
file and everthing is ready to go
<br>like kenny suggested, I used kmysql to create a new table I called
"data". you could do this from the command line
<br>The rpm's contained the manuals for MySQL and I pieced together this
code from the docs
<p> //setup the database connection
<br> MYSQL mysql;
<br> mysql_init(&mysql);
<p> if(!mysql_real_connect(&mysql,
"129.138.0.3", "dmrobbin", NULL, "test", 0, NULL, 0))
<br> {
<br> fprintf(stderr, "Failed
to connect to database: Error: %s\n", mysql_error(&mysql));
<br> };
<p> if(mysql_query(&mysql,
"load data local infile \"/tmp/output.txt\" into table data"))
<br> {
<br> fprintf(stderr, "Failed
to connect to database: Error: %s\n", mysql_error(&mysql));
<br> };
<p>// if(mysql_query(&mysql, "insert
into data values ('nov99','put',1295,12.35,43.21)"))
<br>//// {
<br> // fprintf(stderr, "Failed to connect
to database: Error: %s\n", mysql_error(&mysql));
<br>// };
<p>the two msql_query statements put data into the table I created
so they are specific to my table
<p>The docs are pretty extensive, I'm still trying to digest them
<br>the docs to all the API calls are at the end of the documentation
<br>let me know if I can help you out
<p>Dave
<p>"Kenny G. Dubuisson, Jr." wrote:
<blockquote TYPE=CITE><style></style>
<span class=290171519-15111999><font face="Arial"><font color="#0000FF"><font size=-1>Try
checking out KMySql at <a href="http://www.xnot.com/kmysql/">http://www.xnot.com/kmysql/</a>.
Though, from what I can tell, it was not developed using KDevelop, it would
give you a head start. I would suggest contacting the authors to
see if you could work together so that you would get the functions you
need to write your accounting app, and KMySql would get the benefit of
having an accounting app on its resume.</font></font></font></span><span
class=290171519-15111999></span><span class=290171519-15111999><font face="Arial"><font color="#0000FF"><font size=-1>Just
a thought. Hope it helps</font></font></font></span><span
class=290171519-15111999></span><span class=290171519-15111999><font face="Arial"><font color="#0000FF"><font size=-1>Kenny
Dubuisson, Jr.</font></font></font></span><span
class=290171519-15111999><font face="Arial"><font color="#0000FF"><font size=-1>Jackson,
Mississippi, USA</font></font></font></span><span class=290171519-15111999></span><span
class=290171519-15111999></span><span
class=290171519-15111999></span><font face="Tahoma"><font size=-1>-----Original
Message-----</font></font>
<br><font face="Tahoma"><font size=-1><b>From:</b> Mailing list agent [<A HREF="mailto:mdom@barney.cs.uni-potsdam.de">mailto:mdom@barney.cs.uni-potsdam.de</A>]<b>On
Behalf Of </b>Jean-Paul Miniscloux</font></font>
<br><font face="Tahoma"><font size=-1><b>Sent:</b> Friday, November 12,
1999 10:58 AM</font></font>
<br><font face="Tahoma"><font size=-1><b>To:</b> kdevelop@barney.cs.uni-potsdam.de</font></font>
<br><font face="Tahoma"><font size=-1><b>Subject:</b> KDevelop with MySQL</font></font>
<br>
<blockquote style="MARGIN-RIGHT: 0px">Hello, Someone among you, does
he have used KDevelop with MySQL? I am busy to write a software of
accounting and I will like used the databases under MySQL.
<br>I installed MySQL therefore since some RPM files, but I don't know
how use the library. If I have well understood the documentation, it is
necessary that the program includes in client. That I must to put
in the profile of project and which is the includes has to indicate. Thank
you Jean Paul</blockquote>
</blockquote>
</body>
</html>