c# - MySql 语法错误 : You have an error in your SQL syntax near '' at line 1

Question

编辑: 为这个愚蠢的问题道歉。我自己注意力不集中，再加上我仍然只是在学习 SQL 语法，这让我错过了这个问题。

原始问题:我不知道这里发生了什么。我尝试了几种插入数据的方法，但到目前为止都没有奏效，而且我总是遇到同样的异常。我不确定是什么导致了这个问题。我是否缺少命令功能或语法有问题？

string uName = "tess";
string uPwd = "newpassword";
int authorityLevel = 3;

try
{
    mySqlCommand = mySqlConnect.CreateCommand();
    mySqlCommand.CommandText = "INSERT INTO Users(UserName, UserPassword, AuthorityLevel) VALUES(\"" + uName + "\", \"" + uPwd + "\", " + authorityLevel + ";";
    mySqlCommand.ExecuteNonQuery();
}
catch ((MySql.Data.MySqlClient.MySqlException e)
{
    Console.WriteLine(e.Message);
}

// Output:
// 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 '' at line 1

Answer 1

你忘记了一个右尖括号 ) 在

mySqlCommand.CommandText = "INSERT INTO Users(UserName, UserPassword, AuthorityLevel) VALUES(\"" + uName + "\", \"" + uPwd + "\", " + authorityLevel + ";";

用这个代替

mySqlCommand.CommandText = "INSERT INTO Users(UserName, UserPassword, AuthorityLevel) VALUES(\"" + uName + "\", \"" + uPwd + "\", " + authorityLevel + ");";

并且您添加了一个额外的左尖括号(在

catch ((MySql.Data.MySqlClient.MySqlException e)

替换为

catch (MySql.Data.MySqlClient.MySqlException e)