myxql v0.2.0 MyXQL.Result View Source

Result struct returned from any successful query.

Its public fields are:

:columns - The column names;
:connection_id - The connection ID;
:last_insert_id - The ID of the last inserted row;
:num_rows - The number of fetched or affected rows;
:rows - The result set. A list of lists, each inner list corresponding to a row, each element in the inner list corresponds to a column;
:num_warnings - The number of warnings

Warnings

Depending on SQL MODE, a given query may error or just return warnings. If result.num_warnings is non-zero it means there were warnings and they can be retrieved by making another query: MyXQL.query!(conn, "SHOW WARNINGS").

Link to this section Summary

Types

t()

Link to this section Types

t()

t() :: %MyXQL.Result{
  columns: [String.t()] | nil,
  connection_id: pos_integer(),
  last_insert_id: term() | nil,
  num_rows: non_neg_integer() | nil,
  num_warnings: non_neg_integer(),
  rows: [[term()]] | nil
}

myxql

v0.2.0

myxql v0.2.0 MyXQL.Result View Source

Warnings

Link to this section Summary

Types

Link to this section Types

t() View Source t() :: %MyXQL.Result{ columns: [String.t()] | nil, connection_id: pos_integer(), last_insert_id: term() | nil, num_rows: non_neg_integer() | nil, num_warnings: non_neg_integer(), rows: [[term()]] | nil }

t() View Source

t() :: %MyXQL.Result{ columns: [String.t()] | nil, connection_id: pos_integer(), last_insert_id: term() | nil, num_rows: non_neg_integer() | nil, num_warnings: non_neg_integer(), rows: [[term()]] | nil }