SQLUpdate[conn, table, cols, data] updates data in a table in an SQL connection.
WriteDataSource[name] writes a new HSQL data source name.WriteDataSource[name, database] writes a new data source to database.
$SQLTimeout gives the default time in seconds that DatabaseLink waits while opening connections and executing database queries.
$SQLUseConnectionPool gives the default setting that specifies whether a connection pool is used to retrieve a connection.
This section discusses commands that get information about database columns. If you find that the examples in this section do not work as shown, you may need to install or ...
DatabaseLink provides two styles of commands for working with data: one for those who are familiar with Mathematica and the other for those who are familiar with SQL. ...
Database connection pools are a common way to improve the performance of database operations. They can be useful because creating a new connection can easily take several ...
SQLCreateTable creates a new table in a database. An alternative, using raw SQL, is described in "Creating Tables with Raw SQL". If you find that the examples in this ...
HSQLDB is a relational database engine written in Java that is bundled with DatabaseLink, which also contains a JDBC driver and necessary configuration. It offers a small ...
DatabaseLink allows other Mathematica applications to hold resource information for database connections in DatabaseResources directories. There are a number of possible ...