Advertisement
aadddrr

Update Alamat CLAND

Jul 5th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE m_report_parameter_config
  2.     SET parameter_value = 'Jl. Raya Serpong KM. 7 Komplek Multiguna Blok A no.3'
  3.     WHERE report_name = 'ALL' AND tenant_id = 10 AND report_parameter_config_id = 926 AND parameter_key = 'address1'
  4.  
  5.     UPDATE m_report_parameter_config
  6.     SET parameter_value = 'Rt 04/01 Pakualam, Serpong Utara'
  7.     WHERE report_name = 'ALL' AND tenant_id = 10 AND report_parameter_config_id = 927 AND parameter_key = 'address2'
  8.    
  9.     UPDATE m_report_parameter_config
  10.     SET parameter_value = 'Tanggerang Selatan'
  11.     WHERE report_name = 'ALL' AND tenant_id = 10 AND report_parameter_config_id = 929 AND parameter_key = 'city'
  12.  
  13.     UPDATE m_report_parameter_config
  14.     SET parameter_value = 'Banten'
  15.     WHERE report_name = 'ALL' AND tenant_id = 10 AND report_parameter_config_id = 930 AND parameter_key = 'state_or_province'
  16.    
  17.     UPDATE m_report_parameter_config
  18.     SET parameter_value = '15320'
  19.     WHERE report_name = 'ALL' AND tenant_id = 10 AND report_parameter_config_id = 932 AND parameter_key = 'zip_code'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement