WOLFRAM

Wolfram Language & System Documentation Center

Add Data to a Database Table

DatabaseLink allows you to interface with databases. Here, SQLInsert is used to put data in a database table.

    
If you find that these examples do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in "Using the Example Databases".
After loading DatabaseLink and opening a connection, create a table and insert one row of data in it:
Wolfram Language code: Needs["DatabaseLink`"]
Wolfram Language code: conn = OpenSQLConnection[ "demo"];
Wolfram Language code: SQLCreateTable[conn, SQLTable["TEST"], {SQLColumn["COL1", "DataTypeName" -> "INTEGER"], SQLColumn["COL2", "DataTypeName" -> "DOUBLE"]}];
Wolfram Language code: SQLInsert[conn, "TEST", {"COL1", "COL2"}, {10, 10.5}]
Retrieve the row:
Wolfram Language code: SQLSelect[conn, "TEST"]
Insert multiple rows:
Wolfram Language code: SQLInsert[conn, "TEST", {"COL1", "COL2"}, {{10, 10.5}, {20, 55.1}}]
Wolfram Language code: SQLSelect[conn, "TEST"]