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

New to Mathematica? Find your learning path »
Have a question? Ask support »