OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
batch insert

From: wenzhu cui (cuiwenzhu1985hotmail.com)
Date: Thu Feb 26 2009 - 21:59:56 CST



 In C API, I want to insert 10000 sql.

I must have one strSql= insert into tables hello id ,blob values(?,?),(?,?),(?,?)..........。

then bind every pos with mysql_stmt_bind_param().

then to exec.

 

In C API don't have batchexec。

if I can have strSQL = inset into tables hello id,blob values10000((?),(?)).

like this strSQL

thank you ereryone.

 

_________________________________________________________________
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.

http://www.microsoft.com/windows/windowslive/products/photos.aspx