Database Reference
In-Depth Information
Summary
At this point, you should have a good understanding of MySQL and MariaDB. You should
understand the basic structure of a database and its tables. You should now see the value of
having smaller multiple tables. You should no longer envision a database as one large table
or like a spreadsheet. You should have a good sense of columns and how to enter data into
them, especially if you have done all of the exercises at the end of the previous two
chapters. You should not be overwhelmed at this point.
Chapter7
delves more deeply into how to retrieve data from tables using the
SELECT
statement. We have already touched on this SQL statement several times. However, you
saw only a sampling of how you might use
SELECT
in this chapter and in previous ones, to
give you a sense of why we were creating and adding data the way we did to tables. The
next chapter will cover the
SELECT
statement in much more detail.
The
INSERT
,
SELECT
, and the
UPDATE
statements are the most used SQL statements. If
you want to learn MySQL and MariaDB well, you need to know these statements well. You
need to know how to do the basics, as well as be familiar with the more specialized aspects
of using
SELECT
. You'll accomplish that in the next chapter.
Before moving on to the next chapter, though, complete the following exercises. They will
help you to retain what you've learned about the
INSERT
statement in this chapter. Don't
skip them. This is useful and necessary to building a solid foundation in learning MySQL
and MariaDB.
