FoxPro MySQL

# FoxPro create file txt delimited with pipeline
Copy To (hasil) Delimited With "" With Character "|"

# from file above, then import to MYSQL
LOAD DATA LOCAL INFILE 'C:/tmp/coba.txt' INTO TABLE coba
FIELDS TERMINATED BY "|" ENCLOSED BY ""
LINES TERMINATED BY '\r\n'
(nama,alamat,kota)