SQLDelete

deletes the data in a table in an SQL connection.

SQLDelete

deletes data that matches cond.

更多信息

To use SQLDelete, you first need to load DatabaseLink using .

Use this function with caution, as you can lose data permanently!

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

范例

关闭所有单元

例 (1)

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 .

Delete all the data in a table:

Delete data matching a condition:

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