select * from update_db where update_db.value='1' and update_db.group_id ='2' order by update_db.table_name
Select==> SELECT * FROM al_com_branch_customer WHERE log_status in ('e','a') limit 0,500

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='541',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '541';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '541'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#541#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #541#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='529',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '529';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '529'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#529#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #529#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='530',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '530';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '530'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#530#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #530#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='539',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '539';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '539'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#539#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #539#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='528',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '528';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '528'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#528#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #528#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='542',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '542';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '542'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#542#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #542#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='534',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '534';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '534'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#534#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #534#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='533',trans_price ='0.00',cust_status ='1',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '533';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '533'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#533#@trans_price =#0.00#@cust_status =#1#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #533#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='537',trans_price ='0.00',cust_status ='1',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '537';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '537'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#537#@trans_price =#0.00#@cust_status =#1#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #537#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='527',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '527';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '527'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#527#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #527#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='536',trans_price ='0.00',cust_status ='1',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '536';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '536'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#536#@trans_price =#0.00#@cust_status =#1#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #536#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='535',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '535';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '535'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#535#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #535#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='506',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '506';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '506'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#506#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #506#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='505',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '505';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '505'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#505#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #505#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='546',trans_price ='100.00',cust_status ='1',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '546';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '546'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#546#@trans_price =#100.00#@cust_status =#1#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #546#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='517',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '517';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '517'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#517#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #517#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='518',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '518';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '518'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#518#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #518#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='544',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '544';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '544'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#544#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #544#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='543',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '543';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '543'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#543#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#2015-12-08#@log_user =#SYSTEM#@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #543#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='551',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '551';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '551'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#551#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #551#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='553',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '553';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '553'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#553#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #553#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='523',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '523';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '523'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#523#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #523#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='552',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '552';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '552'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#552#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #552#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1634',cust_id ='503',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '503';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1634' and cust_id = '503'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1634#@cust_id =#503#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1634# and cust_id = #503#;')

#STOP # Total Record = 24
Select==> SELECT * FROM al_com_prod_price_center WHERE log_status in ('e','a') limit 0,500

#STOP # Total Record = 0
Select==> SELECT * FROM al_com_prod_spin_center WHERE log_status in ('e','a') limit 0,500

#STOP # Total Record = 0
################## End ##################
Çѹ·Õè 2018-04-21 01:03:25 Group 2
ʶҹÐQuery
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='541',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '541';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='529',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '529';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='530',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '530';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='539',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '539';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='528',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '528';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='542',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '542';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='534',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '534';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='533',trans_price ='0.00',cust_status ='1',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '533';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='537',trans_price ='0.00',cust_status ='1',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '537';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='527',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '527';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='536',trans_price ='0.00',cust_status ='1',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '536';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='535',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '535';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='506',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '506';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='505',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '505';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='546',trans_price ='100.00',cust_status ='1',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '546';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='517',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '517';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='518',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '518';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='544',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '544';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='543',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='2015-12-08',log_user ='SYSTEM',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '543';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='551',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '551';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='553',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '553';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='523',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '523';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='552',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '552';
COMPLETEupdate al_com_branch_customer set branch_id ='1634',cust_id ='503',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1634' and cust_id = '503';

success