CREATE DATABASE `mydatabase` /*!40100 DEFAULT CHARACTER SET latin1 */;




DROP TABLE IF EXISTS `mydatabase`.`mytable`;
CREATE TABLE  `mydatabase`.`mytable` (
  `col#1` int(11) NOT NULL,
  `column #2` varchar(10) DEFAULT NULL,
  `status column #3` int(11) DEFAULT NULL,
  `TableColumn4` int(11) DEFAULT NULL,
  `col/field/number7` varchar(50) DEFAULT NULL,
  `col10` varchar(20) DEFAULT NULL,
  `col 11` int(11) DEFAULT NULL,
  `col12` varchar(50) DEFAULT NULL,
  `col 13` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



LOAD DATA LOCAL INFILE 'C:/mysql/data/mydatabase/mydatabase.csv' INTO TABLE `mydatabase`.`mytable`
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
IGNORE 1 LINES (`col#1`,`column #2`,`status column #3`,`TableColumn4`,`col/field/number7`,`col10`,`col 11`,`col12`,`col 13`)
;

1, 'stat col2', 300, 41234, 'this is a var char 550', 'varchar,610', 0, 'boring8', 'boring9'
2, 'stat,col2', 333, 41234, 'this is a var char 551', 'varchar,611', 0, 'boring8', 'boring9'
3, 'stat col2', 300, 41234, 'this is a var char 552', 'varchar,612', 0, 'boring8', 'boring9'
4, 'stat,col2', 333, 41234, 'this is a var char 553', 'varchar,613', 0, 'boring8', 'boring9'
5, 'stat col2', 300, 41234, 'this is a var char 554', 'varchar,614', 0, 'boring8', 'boring9'