the optional result _ mode parameter can be mysql _ use _ result and mysql _ store _ result it defaults to mysql _ use _ result so the result is not buffered see also mysql _ query for the counterpart of this behaviour 