MySqlConnector: MySqlBulkLoader class. Upload empty data from csv to MySQL table
P粉398117857
P粉398117857 2024-04-06 14:35:18

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

P粉398117857
P粉398117857

reply all(1)
P粉781235689

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/

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!