-------------- SELECT version() -------------- +-------------------------+ | version() | +-------------------------+ | 5.0.45-community-nt-log | +-------------------------+ 1 row in set (0.00 sec) -------------- LOAD DATA LOCAL INFILE 'l_coast-CP.dat' INTO TABLE PUBACC_CP FIELDS TERMINATED BY '\|' -------------- Query OK, 5729 rows affected, 5729 warnings (0.80 sec) Records: 5729 Deleted: 0 Skipped: 0 Warnings: 5729 -------------- LOAD DATA LOCAL INFILE 'l_coast-EM.dat' INTO TABLE PUBACC_EM FIELDS TERMINATED BY '\|' -------------- Query OK, 88033 rows affected, 65535 warnings (7.58 sec) Records: 88033 Deleted: 0 Skipped: 0 Warnings: 88033 -------------- LOAD DATA LOCAL INFILE 'l_coast-EN.dat' INTO TABLE PUBACC_EN FIELDS TERMINATED BY '\|' -------------- Query OK, 41470 rows affected, 41470 warnings (14.21 sec) Records: 41470 Deleted: 0 Skipped: 0 Warnings: 41470 -------------- LOAD DATA LOCAL INFILE 'l_coast-FR.dat' INTO TABLE PUBACC_FR FIELDS TERMINATED BY '\|' -------------- Query OK, 84434 rows affected, 65535 warnings (12.32 sec) Records: 84434 Deleted: 0 Skipped: 0 Warnings: 1 -------------- LOAD DATA LOCAL INFILE 'l_coast-HD.dat' INTO TABLE PUBACC_HD FIELDS TERMINATED BY '\|' -------------- Query OK, 28573 rows affected, 28573 warnings (5.33 sec) Records: 28573 Deleted: 0 Skipped: 0 Warnings: 0 -------------- LOAD DATA LOCAL INFILE 'l_coast-HS.dat' INTO TABLE PUBACC_HS FIELDS TERMINATED BY '\|' -------------- Query OK, 135104 rows affected, 65535 warnings (7.70 sec) Records: 135104 Deleted: 0 Skipped: 0 Warnings: 135104 -------------- LOAD DATA LOCAL INFILE 'l_coast-LO.dat' INTO TABLE PUBACC_LO FIELDS TERMINATED BY '\|' -------------- Query OK, 29197 rows affected, 65535 warnings (7.35 sec) Records: 29197 Deleted: 0 Skipped: 0 Warnings: 0 Bye