The values of the program variables that have been input through the form can be used
in SQL statements that update tables in a database.
SQL transactions
The embedded SQL statements INSERT, UPDATE, and DELETE can be used to make changes to the contents of a database table.
Concurrency and Consistency
While your program is modifying data, another program may also be reading or modifying the same data. To prevent errors, database servers use a system of locks.