Sams Teach Yourself MySQL in 21 Days, Second Edition

Summary

Today you learned the various ways of getting data into a MySQL database. You learned about the important INSERT, REPLACE, and UPDATE statements in SQL.

You studied the various utilities that can perform bulk inserts and updates, including mysql for processing SQL from a file in batch mode, and mysqlimport for importing data from a text-delimited file. You also learned how to use the latter's SQL equivalent, LOAD DATA INFILE.