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 insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1707','543','300.00','1','p','2018-01-15','62364_1707',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1707' 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(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1707#@#543#@#300.00#@#1#@#p#@#2018-01-15#@#62364_1707#@now());')

#STOP # Total Record = 1
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-01-16 11:57:58 Group 2
ʶҹQuery
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1707','543','300.00','1','p','2018-01-15','62364_1707',now());

success