Delete data with SQLite

Delete data with the WHERE clause

Report a typo

Let's put into practice what we've learned. Below, you have the structure of the Customers table:

CustomerID	CustomerName	Address	City	PostalCode	Country
1	Gerhard Häring	Rosenberg 20	Berlin	97215	Germany

Select the valid way to delete all customers from the city of Lima:

Select one or more options from the list

cursor.executemany("DELETE FROM Customers WHERE city=?", ['Lima'])

cursor.execute("DELETE * FROM Customers WHERE city=?", ['Lima'])

cursor.execute("DELETE FROM Customers WHERE city='Lima'")

cursor.execute("DELETE FROM Customers WHERE city=?", ('Lima',))

___

Create a free account to access the full topic