DatabaseLink SQL Operations
DATABASELINK 概述

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 DatabaseLinkIntroduction to DatabaseLink

Background

Mathematica Database Applications

Features of DatabaseLink

DatabaseLink Technology

Getting StartedGetting Started

About This Tutorial

The Command-Line Interface

Database ConnectionsDatabase Connections

Setting Up a Database

Establishing a ConnectionEstablishing a Connection

Connection Information

JDBC Connections

ODBC Connections

Named Connections

Database Timeouts

Example Connections

The Connection Tool

Database ResourcesDatabase Resources

JDBC Configuration

Connection Configuration

Security and Authentication

Descriptive CommandsDescriptive Commands

Table StructureTable Structure

Table Description

Table Representation

Column StructureColumn Structure

Column Description

Column Representation

Data Types

Schema and Catalogs

Data CommandsData Commands

Comparing Mathematica and SQL Queries

Mathematica-Style QueriesMathematica-Style Queries

Selecting Data

Creating Tables

Inserting Data

Updating Data

Deleting Data

Dropping Tables

SQL-Style QueriesSQL-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 ExplorerThe Database Explorer

The Connection Tool

Querying the Database

Saving Queries

Exporting to Mathematica

New Connection Wizard

Advanced TopicsAdvanced Topics

DataTypeMappingDataTypeMapping

SQLBinary

SQLDateTime

SQLExpr

ResultSetsResultSets

Basic Result Set Operations

SQLResultSet Options

Result Set Positions

Advanced Result Set Operations

Result Set Examples

PerformancePerformance

Batch Operation

Simplifying Substitution Patterns

Result Sets

Descriptive Commands

Connection PoolsConnection Pools

Working with Connection Pools

Connection Pool Options

TransactionsTransactions

Transaction Isolation

Secure Socket Layer (SSL)

ExamplesExamples

Command Cache

Graph Database

AppendixAppendix

Database ReferenceDatabase Reference

HSQLDB

MySQL

PostgreSQL

ODBC

SQL Server

Sybase

Other Databases

JDBC

Using the Example Databases

Send Feedback
Mathematica 9 is now available!

400+ new features, including the new Wolfram Predictive Interface, social network analysis, enterprise CDF deployment, and more »

Try Now
Buy/Upgrade
New to Mathematica? Find your learning path »
Have a question? Ask support »