In this chapter, you learn about some more advanced MySQL topics, including table types, transactions, and stored procedures.
Key topics covered in this chapter include
LOAD DATA INFILE statement
LOAD DATA INFILEStatement
One useful feature of MySQL that we have not yet discussed is the
LOAD DATA INFILE statement. You can use it to load table data in from a file. It executes very quickly.
This flexible command has many options, but typical usage is something like the following:
LOAD DATA INFILE "newbooks.txt" INTO TABLE books;
This line reads row data from the file
newbooks.txt into the table
books. By default, data fields in the file must be separated ...