CSVファイルのインポート方法

DROP TABLE IF EXISTS dbimp;
CREATE TABLE dbimp (NAME varchar(255),NAMEKANA varchar(255),EMAIL varchar(255),COMP varchar(255),COMPKANA varchar(255),PART varchar(255),SECTION varchar(255),GYOSHU varchar(255),ZIP char(8),TDFK varchar(6),ADD1 varchar(255),ADD2 varchar(255),TEL varchar(16),FAX varchar(16),CAT varchar(255),DETAIL varchar(255),TRIG varchar(255),PKG varchar(255),REGDATE varchar(10),APPLY varchar(1),FJID varchar(255),QA varchar(255),ETC varchar(255));
LOAD DATA INFILE "D:/SQLDB/import.csv" INTO TABLE dbimp FIELDS ENCLOSED BY '"' TERMINATED BY "," LINES TERMINATED BY "\r\n";

この

FIELDS ENCLOSED BY '"' TERMINATED BY "," LINES TERMINATED BY "\r\n";

のところがミソだね。