This is documentation for Mathematica 6, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.2)
DatabaseLink Data Access and Manipulation
DatabaseLink provides functions for working with data stored in tables in SQL databases. Operations such as searching, inserting, and deleting are supported. They also convert between the different types of data stored in the database and Mathematica expressions.
SQLSelect select data from a database
SQLInsert, SQLDelete insert and delete data
SQLUpdate update existing data
SQLExecute execute a raw SQL query
SQLArgument a sequence of arguments to a raw SQL query
SQLMemberQ, SQLStringMatchQ test the value of data, in a conditional query
SQLBinary, SQLDateTime, SQLExpr data types
$SQLTimeout how long Mathematica waits while executing queries