Problems mysql in c API

[kishor Mahato]

i am doing project with mysql in c API when I am writing sql query in
c that is accepted and complitely gives the result But how to use
scanf() function in this sql query with C programming.



for example :

sql query( insert into t values (1,'ramesh'); //directly gives values
that's is correct givs the result but

when

scanf("%d",&id) ;
scanf("%d",&name);

and
sql query is
insert into t values(:id,:name); how to use this send me
fast