When it comes to working with data, there are four main operations. In SQL, these operations are
INSERT: Add data to a database table.
SELECT: Read data from one or more tables.
UPDATE: Change existing data.
DELETE: Delete one or more rows from a table.
When we added the image data, we used the INSERT statement. When we created the image gallery, it was the SELECT statement.
In this chapter, we will look at maintaining the image data. This will involve all of the major SQL statements, including UPDATE and DELETE.
As with inserting ...
