& lt; ! - batch adding stores goods - & gt;INSERT INTO goodinstore
(goodid, businessid, retailprice min_stock, stock)
Values(# {item. Good. Id}, # {item. Businessid}, # {item. RetailPrice}, # {item. Min_stock}, # {item. Stock})
ON the DUPLICATE KEY UPDATE
Retailprice=values (retailprice),
Min_stock=values (min_stock),
Stock=values (stock)
What is the meaning of the code below USES?
ON the DUPLICATE KEY UPDATE
Retailprice=values (retailprice),
Min_stock=values (min_stock),
Stock=values (stock)