Testing the import of a CSV file into MySQL

MySQL load infile CSV.md

mysql -utest -p test --local-infile

CREATE TEMPORARY TABLE IF NOT EXISTS `tempy` (
    `tempy_id` INT(21) AUTO_INCREMENT,
    `tempy_value` INT(21) DEFAULT NULL,
    PRIMARY KEY (`tempy_id`)
)ENGINE = InnoDB;

LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE `tempy`
	FIELDS TERMINATED BY ',' ENCLOSED BY '"'
	LINES TERMINATED BY '\r\n'
	IGNORE 1 LINES 
	(`tempy_value`)
;

SELECT * FROM `tempy`;