5.Inserting, Deleting, and Updating Data
In this chapter, we will look at how to insert and change data in your MySQL database with the
We will cover the following:
• Uploading data with
LOAD DATA INFILE
We have now moved into the DML (Data Manipulation Language) aspects of SQL. After we have learned how to insert data into a database, we will spend the next few chapters learning the many and varied ways to retrieve data from a database.
INSERT SQL statement is used to insert rows into a table. We'll begin by looking at an example. Again, you can type these statements directly into the MySQL ...