SQL,为什么添加不上去

来源：百度知道 编辑：UC知道 时间：2024/05/23 00:32:07
sql="Insert into product(name,mark,introduce,price1,price2,price3,price4,price5,price6,vipprice,spic,pic,p1,p2,p3,p4,p5,p6,p7,p8,OtherProperty1,OtherProperty2,OtherProperty3,OtherProperty4,OtherProperty5,categoryid,productdate,discount,score,stock,grade,type,recommend,Supplier,detail,code,pweight,adddate,solded,viewnum,rank,ranknum) values('"&trim(request.form("name"))&"','"&trim(request.form("mark"))&"','"&trim(request.form("introduce"))&"',"&trim(request.form("price1"))&","&trim(request.form("price2"))&","&trim(request.form("price3"))&","&trim(request.form("price4"))&","&trim(request.form("price5"))&","&trim(request.form("price6"))&","&trim(request.form("vipprice"))&",'"&trim(request.form("spic"))&"','"&trim(request.form(&

谁有耐心看完的我就服了……
你一个表弄那么多字段很容易出现冗余的

好长的语句啊
系统提示你的错误是什么？？
最好把提示的错误贴上来看看

@眼晕@
错误提示

我是看不完了，你把语句用SQL执行一下，看下错误提示吧,估计是哪个字段不匹配,顺便把 values 加上!