Code Example 1:

mysql> LOAD DATA INFILE "/my/rawdata/billing.txt" 
       INTO TABLE billing
    -> \g
Query OK, 6 rows affected (0.17 sec)
Records: 6  Deleted: 0  Skipped: 0  Warnings: 1
mysql> LOAD DATA INFILE "/my/rawdata/invoices.txt" 
       INTO TABLE invoices
    -> \g
Query OK, 6 rows affected (0.32 sec)
Records: 6  Deleted: 0  Skipped: 0  Warnings: 0