into tbl_data(retail_price,price,image,inventory_varient,item_no,description,warranty,url)
values(?,?,?,?,?,?,?,?) on duplicate key update item_no=values(?)",
[data.rprice[i].trim(),
data.price[i].trim(),
data.image[i].trim(),
data.local_dc[i].trim(),
data.item_no[i].trim(),
data.description[i].trim(),
data.warrenty[i].trim(),
url,
data.item_no[i]])
What's the error?
You forget ".trim"
Solved In update values(column_name) I am placing data
Обсуждают сегодня