DOCUMENTATION CENTER SEARCH
DatabaseLink SQL Operations
>
DatabaseLink
Overview
DatabaseLink
User Guide
DatabaseLink
is a toolkit for working with SQL databases built into
Mathematica
. It provides an industrial-strength, ready-made solution for integrating
Mathematica
with any standard SQL database.
Introduction to
DatabaseLink
Background
Mathematica
Database Applications
Features of
DatabaseLink
DatabaseLink
Technology
Getting Started
About This Tutorial
The Command-Line Interface
Database Connections
Setting Up a Database
Establishing a Connection
Connection Information
JDBC Connections
ODBC Connections
Named Connections
Database Timeouts
Example Connections
The Connection Tool
Database Resources
JDBC Configuration
Connection Configuration
Security and Authentication
Descriptive Commands
Table Structure
Table Description
Table Representation
Column Structure
Column Description
Column Representation
Data Types
Schema and Catalogs
Data Commands
Comparing
Mathematica
and SQL Queries
Mathematica
-Style Queries
Selecting Data
Creating Tables
Inserting Data
Updating Data
Deleting Data
Dropping Tables
SQL-Style Queries
SQLExecute
Selecting Data with Raw SQL
Creating Tables with Raw SQL
Inserting Data with Raw SQL
Updating Data with Raw SQL
Deleting Data with Raw SQL
Dropping Tables with Raw SQL
The Database Explorer
The Connection Tool
Querying the Database
Saving Queries
Exporting to
Mathematica
New Connection Wizard
Advanced Topics
DataTypeMapping
SQLBinary
SQLDateTime
SQLExpr
ResultSets
Basic Result Set Operations
SQLResultSet Options
Result Set Positions
Advanced Result Set Operations
Result Set Examples
Performance
Batch Operation
Simplifying Substitution Patterns
Result Sets
Descriptive Commands
Connection Pools
Working with Connection Pools
Connection Pool Options
Transactions
Transaction Isolation
Secure Socket Layer (SSL)
Examples
Command Cache
Graph Database
Appendix
Database Reference
HSQLDB
MySQL
ODBC
SQL Server
Sybase
Other Databases
JDBC
Using the Example Databases
© 2008 Wolfram Research, Inc.