RE: Batch UPDATE with C API

2001-06-22 Thread Don Read
On 22-Jun-01 Jean-Philippe Cote wrote: > > > Hello, > > Suppose I want to update n rows (where n is a possibly large number) > using the mySQL C API. I can create n separate UPDATE > statements and send each of them to the server with mysql_[real_]query(), > but that doesn't seem particularly

Batch UPDATE with C API

2001-06-22 Thread Jean-Philippe Cote
Hello, Suppose I want to update n rows (where n is a possibly large number) using the mySQL C API. I can create n separate UPDATE statements and send each of them to the server with mysql_[real_]query(), but that doesn't seem particularly efficient to me. Is there a better way to do it ? Can I