LOAD Data into Tables or Index

Bulk load data efficiently. This section covers commands like LOAD DATA INFILE and LOAD XML for high-speed data import from text or XML files.

LOAD DATA INFILE

Import rows into a table at high speed from a text file, with control over field and line formatting, column mapping, and duplicate handling.

LOAD INDEX

Preload table indexes into the key cache. This command, used for MyISAM tables, loads index blocks into memory to warm up the cache and improve subsequent query performance.

LOAD XML

Read data from an XML file into a table. This command parses XML content, mapping elements and attributes to table columns for direct data import.