> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/load-data-into-tables-or-index.md).

# LOAD Data into Tables or Index

{% columns %}
{% column %}
{% content-ref url="/pages/rx3DLHfLNYrYkxP5adew" %}
[LOAD DATA INFILE](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/load-data-into-tables-or-index/load-data-infile.md)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="/pages/HqMhpckHo6VJMxmjimrL" %}
[LOAD INDEX](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/load-data-into-tables-or-index/load-index.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/qY3nfveISA7tGc2BTdJx" %}
[LOAD XML](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/load-data-into-tables-or-index/load-xml.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}