Must I call mysql_stmt_fetch() for all rows of a result set?

[Uli Klaasberg]

Hi,

is it neccessary to call mysql_stmt_fetch() for all rows of a *non_buffered* result set? Or can I safely exit the fetch loop before retrieving all rows?

For mysql_fetch_row() and mysql_use_result(), the manual says "you must execute mysql_fetch_row() until a NULL value is returned, otherwise, the unfetched rows are returned as part of the result set for your next query."

So how is this with prepared statements? I did a little test with a break inside a fetch loop, and all seems ok, but it would be good to have some more reliable informations.

MySQL Server is 5.1.40

Thanks for help,
Uli