Working with rows
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.
Inserting rows
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...
