INSERT INTO查询错误 [英] error with INSERT INTO query

问题描述

大家好，我在运行插入查询时遇到错误，我完全不知道这个错误是什么或者如何处理它从未见过，请在此之前寻求帮助.我的代码是

hi all im getting an error when i run my insert query i have absoloutly no idea what this error is or how to handle it never seen it before please need help with this my code is

MySql.Data.MySqlClient.MySqlCommand audit_update = new MySql.Data.MySqlClient.MySqlCommand("INSERT INTO audit (member_id, date_time, table, field, old_value, new_value) VALUES (@member_id, @date_time, @table, @field, @old_value, @new_value,)", con5);
            audit_update.Parameters.AddWithValue("@old_value", first_name_hidden.Text);
            audit_update.Parameters.AddWithValue("@field", table.ToString());
            audit_update.Parameters.AddWithValue("@table", false.ToString());
            audit_update.Parameters.AddWithValue("@new_value", tbFirstName.Text);
            audit_update.Parameters.AddWithValue("@member_id", member_id.Text);
            audit_update.Parameters.AddWithValue("@date_time", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));

我得到的异常错误是这样的:

您的SQL语法有误；检查与您的MySQL服务器版本相对应的手册以获取正确的语法，以在``table，field，old_value，new_value)VALUES(``53''，``2012-10-18 12:27:14''，第1行的"False"''

exception error im getting is this:

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 ''table, field, old_value, new_value) VALUES (''53'', ''2012-10-18 12:27:14'', ''False'''' at line 1

推荐答案

INSERT INTO audit (member_id, date_time, table, field, old_value, new_value) VALUES (@member_id, @date_time, @table, @field, @old_value, @new_value,)";

您的上述查询中有多余的，".删除它，然后运行您的查询.并且您将使用已经用作Keyword的列名.

谢谢

In your above query there is extra '',''. Remove that and then run your query. and also you are taking your Column name which are already used as a Keyword.

Thanks

摘下最后一个逗号:

Take off the final comma:

"INSERT INTO audit (member_id, date_time, table, field, old_value, new_value) VALUES (@member_id, @date_time, @table, @field, @old_value, @new_value,)"

成为:

"INSERT INTO audit (member_id, date_time, table, field, old_value, new_value) VALUES (@member_id, @date_time, @table, @field, @old_value, @new_value)"

这怎么办?
改变这个

how about this?
change this

"INSERT INTO audit (member_id, date_time, table, field, old_value, new_value) VALUES (@member_id, @date_time, @table, @field, @old_value, @new_value)"

对此

to this

"INSERT INTO `audit` (`member_id`, `date_time`, `table`, `field`, `old_value`, `new_value`) VALUES (@member_id, @date_time, @table, @field, @old_value, @new_value)"

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