本文介绍了一种使用SQL语句更新数据库中产品名称的方法。通过联接多个表并根据产品型号匹配来实现产品名称的批量更新。
update products,products_description,临时表名 set products_name = 临时表名.name where products.products_id = products_description.products_id and products.products_model = 临时表名.model
update products,products_description,templink
set products_name = templink.name
where products.products_id = products_description.products_id
and products.products_model = templink.model
update products,templink
set products.name = templink.name
where products.model = templink.model
set products_name = templink.name
where products.products_id = products_description.products_id
and products.products_model = templink.model
update products,templink
set products.name = templink.name
where products.model = templink.model
扫一扫
4087
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
