Question

How can you delete the existing records from a table in SQLite?

Answer 1

In SQLite, DELETE command is used to delete the existing records from a table. You should use the WHERE clause to choose the specific row otherwise all rows will be deleted.

Syntax:

DELETE FROM table_name    

WHERE [conditions....................];