DatabaseLink Symbol

SQLSelect

SQLSelect[conn, table]
extracts data from a table in an SQL connection.

SQLSelect[conn, table, cols]
extracts data from particular columns.

SQLSelect[conn, table, cols, cond]
only extracts data that matches cond.

MORE INFORMATION

To use SQLSelect, you first need to load DatabaseLink using Needs["DatabaseLink`"].

The following options can be given:

"Distinct"	False	whether to return only distinct results
"GetAsStrings"	False	whether to return the results as strings
"MaxRows"	Automatic	the maximum number of rows to return
"ShowColumnHeadings"	False	whether to return headings with the results
"SortingColumns"	None	how to sort the data
"Timeout"	None	the timeout for the query

EXAMPLES

CLOSE ALL

Basic Examples (1)

Needs["DatabaseLink`"]

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package, as described in Using the Example Databases.

In[2]:=

Select all data from a table:

In[3]:=

Out[3]=

Select only certain columns:

In[4]:=

Out[4]=

Join data from multiple tables:

In[5]:=

Out[5]//Short=

Select data matching a condition:

In[6]:=

Out[6]=

Select data matching a pattern:

Select data matching a list:

In[9]:=

Out[9]=

In[10]:=

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package, as described in Using the Example Databases.

Scope (1)

Options (2)

Applications (1)