在 INSERT INTO 语句中出现语法错误 [英] Getting syntax error in INSERT INTO statement

问题描述

所以我遇到了这个问题，我尝试了一切.有点卡

So I'm receiving this problem, I tried everything. Kinda stuck

我的访问数据库设计:

ID - AutoNumber
Data - ShortText

还有插入命令:

OleDbCommand command = new OleDbCommand();

string sql = "INSERT INTO Table (Data) VALUES (@Data)";
OleDbCommand cmd = new OleDbCommand(sql, connection);
cmd.Parameters.AddWithValue("@Data", "Test");

connection.Open();

try
{
    cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
    MessageBox.Show("err: " + ex);
    throw;
}

connection.Close();

这可能很愚蠢，但我真的很迷茫，我不知道该怎么办.

This might be dumb but I'm really lost and I have no idea what to do.

推荐答案

TABLE 是一个 保留关键字 所以你应该改变它的名字或者你应该把它放在方括号里，比如[Table]:

The TABLE is a reserved keyword so you should change it's name or you should enclose it in square brackets like [Table]:

string sql = "INSERT INTO [Table] (Data) VALUES (@Data)";

这篇关于在 INSERT INTO 语句中出现语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！