MySQL Cookbook

Chapter 10. Importing and Exporting Data

Section 10.1.  Introduction

Section 10.2.  Importing Data with LOAD DATA and mysqlimport

Section 10.3.  Specifying the Datafile Location

Section 10.4.  Specifying the Datafile Format

Section 10.5.  Dealing with Quotes and Special Characters

Section 10.6.  Importing CSV Files

Section 10.7.  Reading Files from Different Operating Systems

Section 10.8.  Handling Duplicate Index Values

Section 10.9.  Getting LOAD DATA to Cough Up More Information

Section 10.10.  Don't Assume LOAD DATA Knows More than It Does

Section 10.11.  Skipping Datafile Lines

Section 10.12.  Specifying Input Column Order

Section 10.13.  Skipping Datafile Columns

Section 10.14.  Exporting Query Results from MySQL

Section 10.15.  Exporting Tables as Raw Data

Section 10.16.  Exporting Table Contents or Definitions in SQL Format

Section 10.17.  Copying Tables or Databases to Another Server

Section 10.18.  Writing Your Own Export Programs

Section 10.19.  Converting Datafiles from One Format to Another

Section 10.20.  Extracting and Rearranging Datafile Columns

Section 10.21.  Validating and Transforming Data

Section 10.22.  Validation by Direct Comparison

Section 10.23.  Validation by Pattern Matching

Section 10.24.  Using Patterns to Match Broad Content Types

Section 10.25.  Using Patterns to Match Numeric Values

Section 10.26.  Using Patterns to Match Dates or Times

Section 10.27.  Using Patterns to Match Email Addresses and URLs

Section 10.28.  Validation Using Table Metadata

Section 10.29.  Validation Using a Lookup Table

Section 10.30.  Converting Two-Digit Year Values to Four-Digit Form

Section 10.31.  Performing Validity Checking on Date or Time Subparts

Section 10.32.  Writing Date-Processing Utilities

Section 10.33.  Using Dates with Missing Components

Section 10.34.  Performing Date Conversion Using SQL

Section 10.35.  Using Temporary Tables for Data Transformation

Section 10.36.  Dealing with NULL Values

Section 10.37.  Guessing Table Structure from a Datafile

Section 10.38.  A LOAD DATA Diagnostic Utility

Section 10.39.  Exchanging Data Between MySQL and Microsoft Access

Section 10.40.  Exchanging Data Between MySQL and Microsoft Excel

Section 10.41.  Exchanging Data Between MySQL and FileMaker Pro

Section 10.42.  Exporting Query Results as XML

Section 10.43.  Importing XML into MySQL

Section 10.44.  Epilog