mysql in collaboration with c++

pssheba · #1 (**permalink**) 12-05-04, 12:08

I want to insert values to a mysql table from inside a c++ program such as:

Code:

int main()

   // the following is a mysql command
   use MyDb;

   for(int i=0; i++; i<10)

      // The following is a mysql command
      INSERT INTO MyTable(Counter)
     VALUES(i);

   return(0);

can anyone explain me how i can contact my local mysql server (in 'localhost')
and how do i write the above mysql lines in a c++ syntax ?
Tanks !

Aerodyne · #2 (**permalink**) 12-06-04, 04:30

Hi,

Haven't used C++ to conect to a MySQL db yet ...but you could probably try these links for more info:

C connection API: http://dev.mysql.com/doc/mysql/en/my...l_connect.html

C++ info:
http://tangentsoft.net/mysql++/

pssheba · #3 (**permalink**) 12-08-04, 09:54

an i use the c code and save myself downloading mysql++?

drahul · #4 (**permalink**) 12-09-04, 03:42

You need to link your program against the mysql client libraries , which provides you a set of API for connecting and quering the database. The steps are really simple.

check out http://dev.mysql.com/doc/mysql/en/MySQL_APIs.html

they are C API's can be very well used in C++ code.

Internet Services

Web Development

Digital Marketing

Consumer Tech