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
Working with rows
In this section, we will discuss how to write data in MariaDB. Any general-purpose storage system implements ...
Get MariaDB Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
