Is there a way to block insert into mysql(5.0) using c api of mysql
db..

i.e.


say there is a table with 2 columns, one contains char other int
then i want to insert 500 records at once,, as i explained below.

here i declare 2 arrays of char and int to store the values i want,


char *pzCol1[500*50];
int *piCol2[500];


then i fil abov 2 arrays wit values and then the PROBLEM...
Is there a way to above 500 records using below insert query usin' "c
api" of mysql db..


INSERT INTO table VALUES (?, ?)


PLS HLP me.........