【无标题】

• 欢迎使用Markdown编辑器

在学习时使用Java的JDBC来执行SQL语句LOAD DATA导入数据时出现了一个问题，The used command is not allowed with this MySQL version。
后来发现是sql语句的问题，记录一下。
下面是原始SQL语句。

String sql = " LOAD DATA LOCAL INFILE 'd:/party.txt' INTO TABLE department " + 
" FIELDS TERMINATED BY '\t' n" + " LINES TERMINATED BY '\r\n' n" + " ; ";

修改后，也就是删除了LOCAL就正常了。

String sql = " LOAD DATA INFILE 'd:/party.txt' INTO TABLE department " + 
" FIELDS TERMINATED BY '\t' n" + " LINES TERMINATED BY '\r\n' n" + " ; ";