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 Wolfram Language 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 the Wolfram Language waits while executing queries