c++ in collaboration with mysql

[PsSheba]

Does any one know how to contact a mysql server through a c++ application ?
I'd like to run a code such as:

int main()
// this 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);
retrun (0);

can anyone guide me how to write the mysql commands using c++ code ?
Thanks/