extracts data from a table in an SQL connection.
extracts data from particular columns.
only extracts data that matches cond.
- 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 "FetchSize" Automatic JDBC driver hint for filling result sets "GetAsStrings" False whether to return the results as strings "MaxFieldSize" Automatic byte limit for variable-length column types "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 "ColumnSymbols" None symbols to be associated with results "Timeout" $SQLTimeout the timeout for the query
Examplesopen allclose all
Basic Examples (1)
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 DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.