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.