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.

See Also:

w3schools SQL Tutorial
A good introduction to SQL commands can be found on the w3schools website at http://www.w3schools.com/sql/default.asp.