DROP TABLE data._01_abc;
CREATE TABLE data._01_abc (
var1(22) NULL,
var2 int NULL,
var3 char(2) NULL);
LOAD DATA INFILE "sql.csv"
INTO TABLE data._01_abc
COLUMNS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 LINES;
DROP TABLE data._01_abc;
CREATE TABLE data._01_abc (
var1(22) NULL,
var2 int NULL,
var3 char(2) NULL);
LOAD DATA INFILE "sql.csv"
INTO TABLE data._01_abc
COLUMNS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 LINES;