SEARCH MATHEMATICA 8 DOCUMENTATION

THIS IS DOCUMENTATION FOR AN OBSOLETE PRODUCT.
SEE THE DOCUMENTATION CENTER FOR THE LATEST INFORMATION.

DatabaseLink Symbol

Tutorials »|More About »

SQLUpdate

SQLUpdate[conn, table, cols, data]
updates data in a table in an SQL connection.

MORE INFORMATION

To use SQLUpdate, you first need to load DatabaseLink using Needs["DatabaseLink`"].

Returns an integer specifying the number of rows affected by the query.

The following option can be given:

"Timeout"

None

the timeout for the query

EXAMPLES

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

Create a table and insert some data:

Update only data matching a condition: