LOAD DATA [LOCAL] INFILE file [REPLACE|IGNORE] INTO TABLE table [delimiters] [(columns)]Simply using "LOAD DATA INFILE" will assume tab delimited. Other options include: "FIELDS TERMINATED BY 'c'", "FIELDS ENCLOSED BY 'c'", "FIELDS ESCAPED BY 'c'", "LINES TERMINATED BY 'c'". for ur case, it might be load data infile a.csv into table abc;
mysql -h localhost -u root < importFile
load data infile path\filename.txt into table database.tablename建议你用mysql-front,很方便
INTO TABLE table [delimiters] [(columns)]Simply using "LOAD DATA INFILE" will assume tab delimited. Other options
include: "FIELDS TERMINATED BY 'c'", "FIELDS ENCLOSED BY 'c'", "FIELDS
ESCAPED BY 'c'", "LINES TERMINATED BY 'c'".
for ur case, it might be
load data infile a.csv into table abc;