Hello guys
Here's the case. I have a table that contains customer data. Now that the data will be automatically exported to a .txt file with a specific format.
txt files will be updated when we also add / update the table.
provisions like this:
**FieldName Type Description**
TRANCODE N 04 '0005' = add/update '0013'=delete
SEQNO N 06 Sequence number. Rigt justified, leading zeros
INSTCODE AN 06 Institution code (3 digit). Left justified.
DEPTCODE N 04 default '0001'
CUSTOMERREF AN 16 8888+12digit id_customer
exp :
8891123456789012
CUSTOMERID AN 16 8888+12digit id_customer
exp :
8891123456789012
NAME AN 30 Nama customer
BIRTHDATE N 08 Due Date, format = yyyymmdd
default '00000000'
REGDATE N 08 Reg date format = yyyymmdd
CCY N 03 Currency code - 360=IDR; 840=USD, etc.
Sample
0005000001889 00018891123456789012UMAR 0000000000000000360
0005000001889 00018891123456789023EMIR 0000000000000000360
0005000001889 00018891123456789034BUDI 0000000000000000360
So how could my table in MySQL automatic export to. Txt like this ..
please stuffed from all the master
