In this section, we will discuss how to write data in MariaDB. Any general-purpose storage system implements four basic operations that are summarized with the acronym CRUD:
Create: the addition of a new item
Read: obtaining information about an item
Update: Modifying information about an existing item
Delete: Deletion of an existing item
The Read operation is the most complex and will be discussed in the Reading rows section, later. But first, we need to write some data into our database. So this section focuses on the
Create, Update, and Delete operations. Enforcing data integrity is also a fundamental functionality of a relational DBMS, so we will also discuss it here.
In Chapter 2, Databases and Tables, in the Working with tables section, we created a table called product that contains information about the products on sale in our online shop. Of course, when a table is created, it is empty. It has columns and indexes meant to store data, but it does not...