在mysql和asp.net上传问题 [英] uploading problem in mysql and asp.net

问题描述

先生，为什么它没有语法错误时无效。这是我的（字符串insquery =INSERT INTO sla（月，年，内容类型）VALUES（@month，@ year，@ contenttype）;）查询工作正常但为什么它不起作用（LOAD DATA INFILE+ path +INSERT INTO TABLE sla1 FIELDS TEDINATED BY''''LINES INATEDIN''\ n''n''NNON 1 LINES）





并给出错误......

错误：您的SQL语法有错误;查看与您的MySQL服务器版本相对应的手册，以便在D：\ Book1111.csv附近使用正确的语法INSERT INTO TABLE sla1 FIELDS TERMINATED BY''，''LINES TERMINATE''在第1行



并且代码预先发送给您。





请给出解决方案...... ..........

Sir why it not work when there is no syntax error.Here my (string insquery = "INSERT INTO sla (month, year, contenttype) VALUES(@month, @year, @contenttype)";) that query work fine but why it will not work (LOAD DATA INFILE " + path + " INSERT INTO TABLE sla1 FIELDS TERMINATED BY '','' LINES TERMINATED BY ''\n'' IGNORE 1 LINES)


and given error......
Error: 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 ''D:\Book1111.csv INSERT INTO TABLE sla1 FIELDS TERMINATED BY '','' LINES TERMINATE'' at line 1

And code is previsouly send to you.


Please give a solution.............

推荐答案

尝试添加引号：

Try adding quotes:

LOAD DATA INFILE " + path + " INSERT INTO TABLE sla1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES

成为

Becomes

LOAD DATA INFILE '" + path + "' INSERT INTO TABLE sla1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES

这篇关于在mysql和asp.net上传问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！