我正试图直接从assets/temp/filename将csv文件大容量插入mysql表users_csv_import。
我得到mysql语法错误,我找不到它。
function bulk_insert_file($filename) {
$file_location = 'assets/temp/'.$filename;
$sql = "LOAD DATA INFILE '".$file_location."' INTO TABLE users_csv_import
TERMINATED BY ''r'n'";
$this->db->query($sql);
}
获取此错误:
Error Number: 1064
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 2
LOAD DATA INFILE 'assets/temp/new_users_template24.csv' INTO TABLE users_csv_import TERMINATED BY ' '
Filename: C:'Program Files (x86)'Ampps'www'system'database'DB_driver.php
行号:330
您在查询语法中有一个错误,您在其中不匹配了一些引号。应为:
$sql = "LOAD DATA INFILE '".$file_location."' INTO TABLE users_csv_import
FIELDS TERMINATED BY ',' LINES TERMINATED BY ''r'n'";