Chapter 3. Getting Started with SQL
In the previous chapters, we learned how to install MariaDB, and to create a database with some tables. Now that we know how to do this, we can use MariaDB for its main purpose: working with data!
In this chapter, we will discuss the statements used to add, modify, or delete data in the database as well as the queries to extract the information that we need. We will cover the following topics in this chapter:
Working with rows
Understanding transactions
Foreign keys
Dealing with duplicate rows and other errors
Reading rows
Joining tables
Working with operators
Working with time and date values
Comments