Deleting Data with Raw SQL
If you find that the examples in this tutorial 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".
When deleting data, the result of SQLExecute is an integer specifying the number of rows affected by the query.
As discussed in "Creating Tables with Raw SQL", the ADDRESSES and MAILER tables should be created.
This executes an SQL statement that deletes a row in the MAILER table. It deletes any rows for which the value in the SENDMAILER column is 0 (or False). Delete statements can be created using conditions that depend on the values in columns. Since one row has been deleted, the result is 1.
Using prepared statements, you can dynamically create SQL statements that delete data within the database. You can combine this with a simple Wolfram Language function. This example deletes an address for a particular user.