sqlite commands

To delete all rows in a table do:

delete from TABLE;