我们正在使用加载数据填充
$this->db->query("LOAD DATA LOCAL INFILE '".$file_path."'
INTO TABLE excel_details
CHARACTER SET utf8mb4
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(Email,name,address)
SET cid =".$cid.", csvsheet_id=".$csvsheet_id
);字符串包含破折号原因1300错误地址包含2–5
1条答案
按热度按时间dtcbnfnu1#
这是无效的sql
(Email,name,address) // address content 2–5. 如果要在sql中进行注解，必须使用--对于单行注解或/* */对于多行。