On Nov 2, 3:55 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> Waruna wrote:
> > 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.........
>
> SQL doesn't know anything about C arrays. But you can dynamically build
> the INSERT statement string and have it insert as many values as you want.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

But the thing is...... what i've mentioned above is totally doable in
Oracle using its C API...