update member_registration
set 
  member_name   = 'member name',   
  fh_name       = 'member father name', 
  add_1         = 'add_1',
  add_2         = 'add_2',
  add_3         = 'add_3', 
 -- country_code  = 'xxxxxxxxxx', 
  phone_no      = 'ph-1234567',
  phone_office  = 'office-1234567',
  mobile_no     = 'mobile-1234567',
  fax_no	= 'fax_no',
  email_address = 'email_address'
 -- nationality   = 'xxxxxxxxxx',	
 -- city_code     = 'xxxxxxxxxx' 	

go


update member_registration_dt
set 
  nom_name      	= 'nom_name ' ,   
  nom_fh_name   	= 'nom_fh_name', 
  nom_id_no     	= 'nom_id_no',
  nom_add_1     	= 'nom_add_1',
  nom_add_2     	= 'nom_add_2', 
  nom_contact_no	= 'nom_contact_no', 
  perm_add_1    	= 'perm_add_1',
  perm_add_2    	= 'perm_add_2',
  perm_add_3    	= 'perm_add_3'
 -- perm_country_code	= 'xxxxxxxxxx',
 -- perm_city_code 	= 'xxxxxxxxxx'	

go

update member_info_hd
set 
    member_name = 'member name' ,   
    fh_name     = 'member father name',   
    add_1       = 'add_1',
    add_2       = 'add_2',
    add_3       = 'add_3', 
    nid_no      = 'nid_no'
--    country_code= 'xxxxxxxxxx', 
--    city_code   = 'xxxxxxxxxx' 	

go

update member_communications
set device_no =   'device_no' 	
go

update accounts
set account_title = 'account_title',
    short_title   = 'short_title'
go

update accounts_address
set 	add_1		= 'add_1',
	add_2		= 'add_2',
	add_3		= 'add_3',   
--	country_code 	= 'XXXXXXXXXXXX',
--	city_code	= 'XXXXXXXXXXXX',   
 --       area_code	= 'XXXXXXXXXXXX',   
	proprietor_name = 'proprietor_name',   
	mobile_no	= 'mobile-1234',   
	phone_office	= 'ph-1234567',   
	email_address	= 'email_address'   

go