Mathematica 9 is now available
SEARCH MATHEMATICA 8 DOCUMENTATION
THIS IS DOCUMENTATION FOR AN OBSOLETE PRODUCT.
SEE THE DOCUMENTATION CENTER FOR THE LATEST INFORMATION.
DatabaseLink SymbolTutorials »|More About »

SQLInsert

SQLInsert[conn, table, cols, data]
inserts data into a table in an SQL connection.
  • To use SQLInsert, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following option can be given:
"Timeout"Nonethe timeout for the query
EXAMPLESCLOSE ALL
Basic Examples   (1)
Needs["DatabaseLink`"]
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package, as described in Using the Example Databases.
In[2]:=
Click for copyable input
In[3]:=
Click for copyable input
Insert one row:
In[4]:=
Click for copyable input
Out[4]=
In[5]:=
Click for copyable input
Out[5]=
Insert multiple rows (batch insert):
In[6]:=
Click for copyable input
Out[6]=
In[7]:=
Click for copyable input
Out[7]=
In[8]:=
Click for copyable input
In[9]:=
Click for copyable input
© 2013 Wolfram Research, Inc. Japanese