Function queryRow

Execute a one-off SQL SELECT command where you only want the first Row (if any).

If the SQL command does not produce a result set (such as INSERT/CREATE/etc), then mysql.exceptions.MySQLNoResultRecievedException will be thrown. Use exec instead for such commands.

Use this method when you are not going to be using the same command repeatedly and you are CERTAIN all the data you're sending is properly escaped. Otherwise consider using mysql.prepared.Prepared.

If there are long data items among the expected result columns you can use the csa param to specify that they are to be subject to chunked transfer via a delegate.

Prototype

std.typecons.Nullable!(mysql.result.Row) queryRow(
  Connection conn,
  string sql,
  ColumnSpecialization[] csa = null
);

Parameters

NameDescription
conn An open Connection to the database.
sql The SQL command to be run.
csa An optional array of ColumnSpecialization structs.

Returns

Nullable!Row: This will be null (check via Nullable.isNull) if the query resulted in an empty result set.

Authors

Copyright

License