mysql插入报错在字段前加表名解决

最新推荐文章于 2024-04-26 13:29:49 发布

MAILJMQ

最新推荐文章于 2024-04-26 13:29:49 发布

阅读量89

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/MAILJMQ/article/details/132182234

版权

mysql插入报错在字段前加表名解决

string 日期 = DateTime.Now.ToString();
textBox1.Text = 日期;
//“insert into opcs set VIN = ‘1234jiang’”
string SQL1 = " insert into opcs set ";
// SQL1 = SQL1 + TXTVIN.Text + “‘,’”;
// SQL1 = SQL1 + TXTKRN.Text + “')”;
//SQL1 = SQL1 + “(‘VIN111’,’ 3333’, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 , 12 , 13, 14);”;

        SQL1 = SQL1 + "opcs.VIN='" + TXTVIN.Text + "', ";
        SQL1 = SQL1 + "opcs.KRNshort='" + TXTKRNshort.Text + "' , ";
        SQL1 = SQL1 + "opcs.3GB010000D=" + TXT3GB010000D.Text + " , ";
        SQL1 = SQL1 + "opcs.3GB010000G=" + TXT3GB010000G.Text + " , ";
        SQL1 = SQL1 + "opcs.3GB010000J=" + TXT3GB010000J.Text + " , ";
        SQL1 = SQL1 + "opcs.3GB010000H=" + TXT3GB010000H.Text + " , ";
        SQL1 = SQL1 + "opcs.04E906262JA=" + TXT04E906262JA.Text + " , ";
        SQL1 = SQL1 + "opcs.04E906262JB=" + TXT04E906262JB.Text + " , ";
        SQL1 = SQL1 + "opcs.04E906262JC=" + TXT04E906262JC.Text + " , ";
        SQL1 = SQL1 + "opcs.04E906262JD=" + TXT04E906262JD.Text + " , ";
        SQL1 = SQL1 + "opcs.8S0906262B=" + TXT8S0906262B.Text + " , ";
        SQL1 = SQL1 + "opcs.06K906262CF=" + TXT06K906262CF.Text + " , ";
        SQL1 = SQL1 + "opcs.04E906262HJ=" + TXT04E906262HJ.Text + " , ";
        SQL1 = SQL1 + "opcs.04E906262JP=" + TXT04E906262JP.Text + " , ";
        SQL1 = SQL1 + "opcs.04E906262HE=" + TXT04E906262HE.Text + " , ";
        SQL1 = SQL1 + "opcs.04E906262JF=" + TXT04E906262JF.Text + " , ";
        SQL1 = SQL1 + "opcs.date='" + 日期 + "' , ";
        SQL1 = SQL1 + "opcs.3GB010000F=" + TXT3GB010000F.Text + " , ";
        SQL1 = SQL1 + "opcs.3GB010000E=" + TXT3GB010000E.Text + " , ";
        SQL1 = SQL1 + "opcs.3GB945307C=" + TXT3GB945307C.Text + " , ";
        SQL1 = SQL1 + "opcs.3GB945307B=" + TXT3GB945307B.Text + " , ";