MySqlConnector: MySqlBulkLoader class. Upload empty data from csv to MySQL table

Question

From MySqlConnector.MySQLBulkLoader class I want to convert csv to MySQL tableKeep null values.

Answer 1

This worked for me:

In the csv file, save empty data, such as \N (without "")

For example (.csv file)

"A US Equity","20220429","ACTV",\N,\N

When you upload a file, MySQl detects that the file is empty:

Configuration document: https://mysqlconnector.net/api/mysqlconnector/mysqlbulkloadertype/