在命令执行期间插入时遇到致命错误 [英] Encountered fatal error while inserting during command execution

问题描述

我的代码如下...请帮助。

my code below... please help.

cmd.CommandText = "LOAD DATA INFILE" + path + "INTO TABLE table1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES(dat1,dat2,dat3,@ts) SET timedtamp = DATE_FORMAT(STR_TO_DATE(@ts,'%d/%m/%Y %H:%i:%s'),'%Y-%m-%d %H:%i:%s')"

        Try
            If conn.State = ConnectionState.Closed Then

                conn.Open()
                cmd.ExecuteNonQuery()
                MsgBox("Data saved successfully.")
                conn.Close()
            End If

        Catch ex As Exception
            MsgBox(ex.Message)
            End
        End Try
    End Sub

我尝试了什么：



cmd.CommandText =LOAD DATA INFILE+路径+INTO TABLE table1 FIELDS TERMINATED BY'，'终止于'\\ n'的IGNORE 1 LINES（dat1，dat2，dat3，@ ts）SET timedtamp = DATE_FORMAT（STR_TO_DATE（@ts，'％d /％m /％Y％H：％i：％s'），'％Y-％m-％d％H：％i：％s'）



尝试

如果conn.State = ConnectionState.Closed那么



conn.Open （）

cmd.ExecuteNonQuery（）

MsgBox（数据保存成功。）

conn.Close（）

结束如果



Catch ex As Exception

MsgBox（ex.Message）

结束

结束尝试

结束Sub

What I have tried:

cmd.CommandText = "LOAD DATA INFILE" + path + "INTO TABLE table1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES(dat1,dat2,dat3,@ts) SET timedtamp = DATE_FORMAT(STR_TO_DATE(@ts,'%d/%m/%Y %H:%i:%s'),'%Y-%m-%d %H:%i:%s')"

Try
If conn.State = ConnectionState.Closed Then

conn.Open()
cmd.ExecuteNonQuery()
MsgBox("Data saved successfully.")
conn.Close()
End If

Catch ex As Exception
MsgBox(ex.Message)
End
End Try
End Sub

推荐答案

在字符串连接中+ path +之前和之后需要一个空格，例如

You need a space before and after + path + in your string concatenation e.g.

cmd.CommandText = "LOAD DATA INFILE " + path + " INTO TABLE table1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES(dat1,dat2,dat3,@ts) SET timedtamp = DATE_FORMAT(STR_TO_DATE(@ts,'%d/%m/%Y %H:%i:%s'),'%Y-%m-%d %H:%i:%s')"

这篇关于在命令执行期间插入时遇到致命错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！