Question

i am new in sql and i want that , i have a table Customer
in which i added a new field Region now i want to do some
alteration in SQL . I want to get all records Customerand check on each

 // This check will perfome for every customer let suppose we have our first customer
if currentcustomer.Country =  US  
 {
  UPDATE currentcustomer SET currentcustomer.Region=currentcustomer.id
 }
 else
 {
    UPDATE  currentcustomer SET currentcustomer.Region=currentcustomer.ZIP
  }

但我不知道如何对待所有顾客, 以及如何在Sql做这件事。

Answer 1

UPDATE Customer SET Region= AA 
WHERE Country =  US 

UPDATE Customer SET Region= ZZ 
WHERE Country <>  US

避免在 SQL 内循环 - 它不是设计用于循环的。

尝试用基于设定的术语来制定您的要求(我需要更新所有客户的国名 US , 以便让区域 AA 和所有其他客户在区域中都具有区域 /code > )。



更新 :

看到您的编辑, 并假设它是合理的( 兼容的数据类型和有意义的数据) :

UPDATE Customer SET Region= id
WHERE Country =  US 

UPDATE Customer SET Region= Zip
WHERE Country <>  US

友情链接