mysql出入语句有关问题

mysql出入语句问题

C# code

        string a = TextBox3.Text;        string b = path.Value;        string c = TextBox5.Text;        string d = TextBox2.Text;        string f = TextBox4.Text;        string sqlstr = "inseret into product(pid,pname,url,details,sortid) values("+"'"+a+"',"+"'"+c+"',"+"'"+b+"',"+"'"+f+"',"+"'"+d+"')";        MySqlCommand sqlcom = new MySqlCommand(sqlstr, sqlconn);        sqlcom.ExecuteNonQuery();

出现如下错误

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 'inseret into product(pid,pname,url,details,sortid) values('1','a','productp/图' at line 1

[解决办法]
mysql插入关键字是inseret吗？insert
[解决办法]
字写错了。

查看更多 下一篇