You mastered the
select statement in Chapter 3, so now it is time to add the rest of the SQL dialect to your capabilities. This chapter covers the remainder of SQL as implemented in SQLite, including
delete statements to modify data; constraints to protect your data; and more advanced topics such as table creation and data types.
select, the commands used to modify data are quite easy to use and understand. There are three Data Manipulation Language (DML) commands for modifying data—
delete—and they do pretty much what their names imply. ...