Query to delete records from SQLite database & printing number of records deleted by using rowcount

List of all Python SQLite tutorials

We can use DELETE query to remove any record by using WHERE condition and giving the id of the record.
Similarly we can remove more records by using WHERE condition to match multiple records.
It is always better to use parameterized queries where the user input is passed separately while executing the query.
We can use multiple parameters to delete records with OR conditions.
SQLite does not support TRUNCATE command so by not using any WHERE condition we can remove all the records.
You can download the zip file containing the Jupiter Note book and the SQLite database file.