querySet

Execute a one-off SQL SELECT command where you expect the entire result set all at once.

This is deprecated because the same thing can be achieved via query(). array().

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.

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.

More...
deprecated
querySet

Parameters

conn Connection

An open Connection to the database.

sql string

The SQL command to be run.

csa ColumnSpecialization[]

An optional array of ColumnSpecialization structs.

Return Value

Type: ResultSet

A (possibly empty) ResultSet.

Detailed Description

Type Mappings

$(TYPE_MAPPINGS)

Examples

// Do this instead of using querySet:
Row[] allAtOnce = myConnection.query("SELECT * from myTable").array;

Meta