Code: Select all
LOAD DATA LOCAL INFILE 'usr/testdata/importfile.csv'
INTO TABLE testtest
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r'
(ProdNum, QtyOnHand, Comment);
Texman
Moderator: General Moderators
Code: Select all
LOAD DATA LOCAL INFILE 'usr/testdata/importfile.csv'
INTO TABLE testtest
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r'
(ProdNum, QtyOnHand, Comment);