Select data matching a condition:

Select the same data using a prepared statement:

Specify a column in a prepared statement:

Give a sequence of arguments in a prepared statement:

Apply a database function to the selected data:

Select only distinct values:

Group values:

Select a range of results:

Join data from multiple tables:

Update data matching a condition:

Use a prepared statement:

Delete data matching a condition:

Use a prepared statement:

Date and time data may be given in a query using DateObject, TimeObject or SQLDateTime. Create a table with DATE, TIME, and DATETIME column types:

Insert one row:

Selected date and time data will return with head SQLDateTime:

Express the selected data in its original form:

Supply a list of symbols for query results to be assigned to:

Create symbols automatically:

Supply a function to operate on column names and results. If column headings have not been requested, the first argument to the function will be Null:

The JDBC specification defines an escape call sequence for authoring queries that would otherwise require vendor-specific SQL. Set the "EscapeProcessing" option to employ defined escape syntax:

Issue a query using escaped SQL:

Issuing the query without escape processing results in an error:

SQL native to this RDBMS may be used without escape processing:

Issue a query using escaped SQL:

Use SQL native to this RDBMS:

Section 13.4 of the JDBC 4.0 Specification contains further information on escape processing and supported functions.

The "FetchSize" option suggests to the JDBC driver a number of rows to fetch on each visit to the database. Increasing this parameter reduces the amount of network traffic required to execute a query, at the cost of memory used:

Compute memory in use, including both kernel and Java layers:

Fetch a large result with small fetch size:

Reset:

Fetch a large result with large fetch size:

Retrieve data without converting it to Wolfram Language types:

Open a connection to a data source that supports generated key retrieval:

Create a table with an auto-incrementing primary key:

Insert rows, returning keys:

Contents of the primary key column:

For some variable-length column types the "MaxFieldSize" option can be used to limit the number of bytes returned for a field:

Create a table with a VARCHAR field:

Insert string data:

Select string contents, limiting byte length of results:

Limit the number of rows returned in a result:

Include column names as the first row of the results:

The column headings are equivalent to the unqualified column names:

Set a timeout value for a particular query:

Adjust batch size to trade off memory use and speed when issuing queries with long parameter lists:

Generate random data for insertion:

Compute memory in use, including both kernel and Java layers:

Run a query with a small batch size, resulting in relatively light Java-side memory use:

Reset:

Rerun with larger batch size, necessitating fewer server trips:

Java memory use is higher in this case:

Switch parameter batching from Java layer to Wolfram Language layer to trade speed for memory:

Generate random data for insertion:

Compute memory in use, including both kernel and Java layers:

Run query with Java-side batching:

Reset:

Run query with Wolfram Language-side batching:

Total memory use is lower in this case: