Transactional Statements

In our running example, we mostly worked with SQL SELECT statements. That is, with queries that read data from the database without modifying it. Though, this is certainly possible with SQL using clauses like INSERT INTO, UPDATE, and DELETE. In our running example of car model parts, we could find ourselves updating the built_at attribute of newly assembled parts: