Full Stack Web Development with Raspberry Pi 3

Delete

To delete records, the DELETE statement is used. Its format is similar to the update statement without any values to set, of course:

    DELETE FROM <table name> WHERE <filter condition>;

If we wanted to make room for new records by deleting all records older than 2017-06-18 12:26:08, we would have the following:

• Table name: temperature
• Filter condition: createdAt < "2017-06-18 12:26:08"

This would result in the following:

      DELETE FROM temperature WHERE createdAt < "2017-06-18 12:26:08";

The resultant table after the update and delete statements is as follows: