mysql - 第 1 行附近的 VB MySQL 语法错误

Question

我收到一条消息，指出第 1 行附近的语法不正确。以下是我正在使用的代码:

Mysqlconn.Open()
Dim Mysqlconn As MySqlConnection
Dim COMMAND As MySqlCommand
Dim ImportDate As DateTime = DateTime.Now
COMMAND = New MySqlCommand("INSERT INTO Main([Character],[Import_Date]) VALUES(@character, @import_date)")
COMMAND.Connection = Mysqlconn
COMMAND.Parameters.AddWithValue("@character", Character.Text)
COMMAND.Parameters.AddWithValue("@import_date", ImportDate)
COMMAND.ExecuteNonQuery()
MessageBox.Show("Ore counts for " & Character.Text & " imported successfully")

Answer 1

语法错误来自字段周围的[]。删除它们。如果您想转义字段，请使用勾号。

COMMAND = New MySqlCommand("INSERT INTO Main
                            (`Character`,`Import_Date`) 
                            VALUES (@character, @import_date)")