Tag

LOAD DATA

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 8, 2022 · Databases

Resolving MySQL LOAD DATA Errors: Handling Date Truncation, Quotes, and Line Terminators

This article walks through a step‑by‑step troubleshooting of MySQL LOAD DATA LOCAL INFILE failures caused by date truncation, quoted CSV fields, and incorrect line terminators, showing how to enable local_infile, use enclosed‑by, @‑variables, and str_to_date to successfully import the data.

CSVLOAD DATAMySQL
0 likes · 12 min read
Resolving MySQL LOAD DATA Errors: Handling Date Truncation, Quotes, and Line Terminators
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 20, 2021 · Databases

DBLE 3.21.02.0 Release Notes Overview

The DBLE 3.21.02.0 release introduces ten new or refactored features, fixes over ten bugs, adds general logging, batch load data mode, fine‑grained SQL statistics, and other enhancements, while also detailing LTS updates, project overview, download links, and community acknowledgments.

DBLEDatabase MiddlewareLOAD DATA
0 likes · 9 min read
DBLE 3.21.02.0 Release Notes Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 25, 2021 · Databases

Using MySQL LOAD DATA for Importing Text and Fixed‑Length Files

This article explains how to use MySQL's LOAD DATA command to import CSV and fixed‑length text files, covering basic parameters, sample data and table structures, four practical scenarios, and best‑practice tips for handling mismatched schemas and large files.

ETLFixed-lengthLOAD DATA
0 likes · 12 min read
Using MySQL LOAD DATA for Importing Text and Fixed‑Length Files
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 12, 2020 · Databases

DBLE LOAD DATA: Design Overview and Source Code Walkthrough

This article explains how DBLE implements the MySQL LOAD DATA large‑scale data import feature, covering the overall design, key classes such as ServerLoadDataInfileHandler and LoadDataUtil, and detailed Java source code handling client‑server interactions, file routing, and backend MySQL communication.

DBLEDatabase MiddlewareJava
0 likes · 9 min read
DBLE LOAD DATA: Design Overview and Source Code Walkthrough