update bmdcustomer set customerid = 1

若想连接其它的表
update a set customerid = 1 
from bmdcustomer a
join ....
delete也一样