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
