Inserting Data - Learning MySQL and MariaDB - page 105

Chapter 6. Inserting Data
After you have created a database and tables, the next step is to insert data. I'm intention-
ally using the word insert because the most common and basic way to enter data into a
table iswith the SQL statement INSERT . It's easier to learn the language of MySQL and
MariaDB, if you use the keywords to describe what you are doing. In this chapter, we will
cover the INSERT statement, its different syntax, and many of its options. We'll use the
tables that we created in Chapter4 and altered in Chapter5 . We'll also look at some related
statements on retrieving or selecting data, but they will be covered in greater detail in
Chapter7 .
When going through this chapter, participate. When examples are given showing the
INSERT statement and other SQL statements, try entering them on your server using the
mysql client. At the end of the chapter are some exercises — do them. They require you to
enter data in the tables that you created in Chapter4 . In doing the exercises, you may have
to refer back to the examples in this chapter and in Chapter4 . This will help to reinforce
what you've read. When you're done, you should feel comfortable entering data in MySQL
and MariaDB.