Deleting Records via SQL Query in Python

The DELETE command lets you delete records from a table. Its syntax is similar to what you learned earlier:

query = "DELETE FROM table WHERE condition"

With the DELETE command, it is necessary to use the commit method:

with connection.cursor(dictionary=True) as cursor:
	cursor.execute(query)
	connection.commit()

Remove user with id equal to 7.

Remove all users who are 23 years old.

Remove all users whose id is greater than 5 and salary is greater than or equal to 900.

Delete all users.