import_json

Aikesheng Open Source Community

Sep 24, 2019 · Databases

Using MySQL Shell Util import_table and import_json for Fast Data Import

This article demonstrates how to use MySQL Shell's util.import_table and util.import_json functions to import CSV and JSON data efficiently, compares their performance with the traditional mysqlimport tool, explains required options such as file path, schema, table, dialect, threading, and shows example sessions in both JavaScript and Python modes.