Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how

Wolfram Language & System Documentation Center

DatabaseLink User Guide

DatabaseLink User Guide

DatabaseLink is a toolkit for working with SQL databases built into the Wolfram Language. It provides an industrial-strength, ready-made solution for integrating the Wolfram Language 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

Installing JDBC Drivers

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

Wolfram Language-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)

Appendix

Database Reference

HSQLDB

MySQL

PostgreSQL

ODBC

SQL Server

Derby

Firebird

H2

SQLite

Sybase

Other Databases

JDBC

Using the Example Databases

Top [フレーム]