Ask a question about commodity attribute and commodity attribute value

Ask a question about commodity attributes and commodity attribute values?
Product List
goods_id cat_id ProductName Price

property sheet
attr_id cat_id Attr_name

Attribute Value table
ID attr_id goods_id Attr_value

When the form is modified


Savedata.asp
You must first delete the delete * from [property value] where goods_id=2 and attr_id=3 and insert into [attribute value] (attr_id,goods_id,attr_value) VALUES (...)

I see Ecshop is such a processing mechanism, gentlemen, what do you think? Do you have to deal with this? Why not update the [property value] set ...
------Solution--------------------
This is the simplest and quickest way to do it once and for all

Otherwise, when you add or delete attributes, you have to decide which ones are deleted. What's new? What changes have been made?
------Solution--------------------
1.delete from Tbname where goods_id=2 and attr_id=3
Yes No *

2.update from Tbname Set ...
This is also possible, the key you need to find the conditions to modify.

------Solution--------------------
If you are modifying multiple records at the same time, a single update is not as fast as inserting multiple records into one insert statement at the same time.

