An open mysql.connection.Connection to the database.
The SQL command to be run.
An optional array of ColumnSpecialization structs.
A (possibly empty) mysql.result.ResultRange.
$(TYPE_MAPPINGS)
ResultRange oneAtATime = myConnection.query("SELECT * from myTable"); Row[] allAtOnce = myConnection.query("SELECT * from myTable").array;
Execute a one-off SQL SELECT command where you want to deal with the result set one row at a time.
If you need random access to the resulting mysql.result.Row elements, simply call std.array.array() on the result.
If the SQL command does not produce a result set (such as INSERT/CREATE/etc), then mysql.exceptions.MYXNoResultRecieved will be thrown. Use exec instead for such commands.
Only use the string sql overload 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 overload that takes a 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.