CREATE DATABASE `mydatabase`



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,
  `column5` varchar(50) DEFAULT NULL,
  `column6` varchar(10) DEFAULT NULL,
  `col/field/number7` varchar(50) DEFAULT NULL,
  `col8` varchar(50) DEFAULT NULL,
  `col9` varchar(20) 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;



set global sql_mode="ANSI_QUOTES,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"



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"