Module Reference

Previous: 1.4.3 Cursor Options Up: 1.4 web.database Next: 1.4.4.1 Understanding Field Types

---

1.4.4 Using SQL Commands

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.

• 1.4.4.1 Understanding Field Types
• 1.4.4.2 Selecting Data
  • 1.4.4.2.1 The where Parameter
  • 1.4.4.2.2 The order Parameter
  • 1.4.4.2.3 The rest Parameter
  • 1.4.4.2.4 Disabling autoExecute
  • 1.4.4.2.5 Using Aliases
  • 1.4.4.2.6 Using Joins
• 1.4.4.3 Inserting Data
• 1.4.4.4 Updating Data
• 1.4.4.5 Deleting Data
• 1.4.4.6 Creating Tables
• 1.4.4.7 Dropping Tables
• 1.4.4.8 Altering Tables
• 1.4.4.9 Functions

---

Module Reference

Previous: 1.4.3 Cursor Options Up: 1.4 web.database Next: 1.4.4.1 Understanding Field Types

---

Documentation released on November 18, 2004 .