java - 在 Java 中使用 LOAD DATA INFILE

Question

我正在尝试从文本文件中读取数据并将它们输入到数据库中。我在适合我的情况的 SQL 文档中找到了这个示例:

LOAD DATA INFILE 'data.txt' INTO TABLE table2 FIELDS TERMINATED BY ',';

所以我正在尝试用 Java 编写它。到目前为止我有这个:

String insertTableSQL = "LOAD DATA INFILE 'C:/Users/Work/Desktop/test/masterDict'"
                    + "INTO TABLE masterdict" + "FIELDS TERMINATED BY \',\'" 
                    ;

但这给了我以下错误:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TERMINATED BY ','' at line 1

Answer 1

你错过了一些空白:

String insertTableSQL = "LOAD DATA INFILE 'C:/Users/Work/Desktop/test/masterDict '"
                    + " INTO TABLE masterdict" + " FIELDS TERMINATED BY \',\'" 
                    ;

因为您的查询字符串将导致:

LOAD DATA INFILE 'C:/Users/Work/Desktop/test/masterDict'INTO TABLE masterdictFIELDS TERMINATED BY \',\'