python 中sql语句传值问题
错误写法
rs = cursor.execute(“insert into product set productName=%s,versonType=%s,hardWareVerson=%s,softWareVerson=%s”%(productName,versonType,hardWareVerson,softWareVerson))
正确写法
query=“insert into product set productName = %s,versonType = %s,hardWareVerson = %s,softWareVerson=%s”
rs=cursor.execute(query, [productName,versonType,hardWareVerson,softWareVerson])