CREATE VIEW CASHPOINTOTHER as
SELECT pay_log_cash.*, '1' as 'payType' FROM pay_log_1
UNION ALL
SELECT pay_log_other.*, '2' as 'payType' FROM pay_log_2
UNION ALL
SELECT pay_log_point.*, '3' as 'payType' FROM pay_log_3 ;
truncate 清空表
SELECT pay_log_point.*, '3' as 'payType' FROM pay_log_3 ;
truncate 清空表