O'Reilly logo

MySQL 5.0 Certification Study Guide by Carsten Pedersen, Stefan Hinz, Paul DuBois

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15 Importing and Exporting Data

This chapter discusses how to perform bulk data import and export operations. It covers the following exam topics:

Image Using the LOAD DATA INFILE statement to import data from files

Image Using SELECTINTO OUTFILE to export data to files

Image Using mysqlimport and mysqldump for importing and exporting data from the command line

15.1 Import and Export Operations

MySQL includes two SQL statements that can be used to import data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required