WOLFRAM LANGUAGE FEATURED EXAMPLE

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 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:
In[1]:=
Click for copyable input
In[2]:=
Click for copyable input
In[3]:=
Click for copyable input
In[4]:=
Click for copyable input
Out[4]=
Retrieve the row:
In[5]:=
Click for copyable input
Out[5]=
Insert multiple rows:
In[6]:=
Click for copyable input
Out[6]=
In[7]:=
Click for copyable input
Out[7]=