1.4.13 Cursor Abstraction Methods

This section describes how to use the following SQL methods of the cursor object:

select(), insert(), update(), delete(), create(), alter(), drop(), function()

These functions are designed to reflect the SQL syntax you would use if you were writing the SQL directly. For example you might write:

SELECT fieldName FROM tableName
INSERT INTO tableName value1, value2

Accordingly the select() and insert() methods accept the fields and table parameters in a different order. It is reccomended however that you always specify parameters by name rather than relying on their order as future versions may have different parameters in different places.