此查询将不会执行其简单的单行查询,我也看不到任何错误,但仍然会给出错误。
INSERT IGNORE INTO Vendors ('Name','Address','Contact','Email','Fax')
VALUES('ehsan','tes# 235t','test','testmailcom','test');
和错误:
Error Code: 1064
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
''Name','Address','Contact','Email','Fax') Values('ehsan','tes# 235t',
'test','tes' at line 1
这是实际的代码:
cmd = new MySqlCommand("Insert IGNORE into Vendors('Name','Address','Contact','Email','Fax') Values(@name,@address,@contact,@email,@fax)", conn);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@contact", contact);
cmd.Parameters.AddWithValue("@email", email);
cmd.Parameters.AddWithValue("@fax", fax);
cmd.ExecuteNonQuery();
在MySql中,您需要用(`)引用字段名称
INSERT IGNORE INTO Vendors (`Name`,`Address`,`Contact`,`Email`,`Fax`)
VALUES('ehsan','tes# 235t','test','testmailcom','test');
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句