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 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:
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]=