mysql-native v1.2.0

API Reference Home: [This Version] [Latest Version] [Other Versions]

Function PreparedImpl.query

Execute a prepared SQL SELECT command where you want to deal with the result set one row at a time.


					
			ResultRange query
			(
			

			  ColumnSpecialization[] csa = null
			

			);

If you need random access to the resulting 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 MYXNoResultRecieved will be thrown. Use exec instead for such commands.

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.

Type Mappings

See the MySQL/D Type Mappings tables

Parameters

Name	Description
csa	An optional array of ColumnSpecialization structs.

Returns

A (possibly empty) ResultRange.

Example

ResultRange oneAtATime = myPrepared.query("SELECT * from myTable");
Row[]       allAtOnce  = myPrepared.query("SELECT * from myTable").array;