Database Connectivity

Mathematica has a built-in high-level interface to all standard SQL databases that allows immediate searching, reading, and writing of arbitrary data and expressions, as well as supporting general SQL database features, including discovery, result sets, and transactions.

ReferenceReference

SQL Database Operations »

OpenSQLConnection connect to any JDBC-compatible SQL database

SQLSelect ▪ SQLUpdate ▪ SQLInsert ▪ SQLDelete ▪ ...

SQLExecute execute any SQL command, generating Mathematica output

SQLTableNames ▪ SQLTableInformation ▪ SQLDataTypeNames ▪ ...

SQLBeginTransaction ▪ SQLResultSetOpen ▪ ...

DatabaseExplorer use a GUI to explore databases and generate notebooks

Import import entire MDB etc. databases

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