- Delete a single and multiple rows, all rows, a single column, and multiple columns from the SQLite table using Python<\/li>
- Use a Python parameterized query to provide value at runtime to the SQLite delete query<\/li>
- Execute a bulk delete using a single query<\/li><\/ul>\n\n\n\n\n\n
Also Read<\/strong>:<\/p>\n\n\n\n
- Solve Python SQLite Exercise<\/a><\/li>
- Read Python SQLite Tutorial (Complete Guide)<\/a><\/li><\/ul>\n<\/div>\n<\/div>\n\n\n\n
Table of contents<\/h2>
- Prerequisite<\/a><\/li>
- Steps to delete a single row from SQLite table<\/a><\/li>
- Use Python Variable in a query to Delete Row from SQLite table<\/a><\/li>
- Delete multiple rows from SQLite table<\/a><\/li>
- Next Steps:<\/a><\/li><\/ul><\/div>\n\n\n\n
Prerequisite<\/h2>\n\n\n\n
\n\nBefore executing the following program, please make sure you know the SQLite table name and its column details.<\/p>\n\n\n\n
For this lesson, I am using the ‘SqliteDb_developers’ table present in my SQLite database.<\/p>\n<\/div>\n\n\n\n
\n![\"sqlitedb_developers](\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/06\/sqlitedb_developers_table_with_data.png\")
sqlitedb_developers table with data<\/figcaption><\/figure><\/div>\n<\/div>\n<\/div>\n\n\n\n If a table is not present in your SQLite database, then please refer to the following articles: –<\/p>\n\n\n\n
- Create SQLite table from Python<\/a>.<\/li>
- Insert data into SQLite Table from Python<\/a><\/li><\/ul>\n\n\n\n
Steps to delete a single row from SQLite table<\/h2>\n\n\n\n
How to delete from SQLite table using Python<\/p>
- Connect to SQLite from Python<\/strong>
Refer to Python SQLite database connection<\/a> to connect to SQLite database from Python using sqlite3 module.<\/p> <\/li>
- Define a SQL Delete Query<\/strong>
Next, prepare a SQL delete query to delete a row from a table. Delete query contains the row to be deleted based on a condition placed in where clause of a query.
DELETE FROM MySQL_table WHERE id=10;<\/code><\/p> <\/li>- Get Cursor Object from Connection <\/strong>
Next, use a
connection.cursor()<\/code> method to create a cursor object. using cursor object we can execute SQL queries.<\/p> <\/li>- Execute the delete query using execute() method<\/strong>
The
cursor.execute(query)<\/code> method executes the operation stored in the delete query.execute()<\/code> method returns the number of rows affected.<\/p> <\/li>- Commit your changes<\/strong>
After successfully executing a delete operation, make changes persistent into a database using the
commit()<\/code> of a connection class.<\/p> <\/li>- Get the number of rows affected<\/strong>
Use a
cursor.rowcount<\/code> method to get the number of rows affected. The count depends on how many rows you are deleting.- Close the cursor object and database connection object<\/strong>
use
cursor.clsoe()<\/code> andconnection.clsoe()<\/code> method to close the cursor and SQLite connections after your work completes.<\/p> <\/li><\/ol><\/div>\n\n\n\nAs of now, the SqliteDb_developers table contains six rows, so let\u2019s remove the developer whose id is 6.<\/p>\n\n\n\n
Example<\/strong><\/p>\n\n\n
- Define a SQL Delete Query<\/strong>
- Insert data into SQLite Table from Python<\/a><\/li><\/ul>\n\n\n\n
- Steps to delete a single row from SQLite table<\/a><\/li>
- Read Python SQLite Tutorial (Complete Guide)<\/a><\/li><\/ul>\n<\/div>\n<\/div>\n\n\n\n
- Solve Python SQLite Exercise<\/a><\/li>