I am working first time database. I had never inserted data into database. I want to insert below csv into mysql database.
Cell id too Issue Valid DPT RH TMP U V 1 1 22383 2015-01-15 00:00:00 GMT 2015-01-15 00:00:00 GMT 269.8000183 80.90000153 272.6300049 3.039999962 -0.560000002 101 1 22089 2015-01-15 00:00:00 GMT 2015-01-15 00:00:00 GMT 270.6000061 79.20000458 273.7599792 2.75 -0.680000007 201 1 22382 2015-01-15 00:00:00 GMT 2015-01-15 00:00:00 GMT 271.1000061 78 274.5499878 2.829999924 -0.099999994 301 1 22675 2015-01-15 00:00:00 GMT 2015-01-15 00:00:00 GMT 271.5 73.70000458 275.7599792 2.700000048 -0.170000002
Could anyone help me in figuring out the data types of the columns?
I have assigned datatypes below but I am getting so many values while inserting data:
CREATE TABLE `raster_cell_data` ( `cell` varchar(100) NOT NULL, `id` varchar(100) NOT NULL, `too` int(14) NOT NULL, `Issue` datetime DEFAULT NULL, `Valid` datetime DEFAULT NULL, `DPT` varchar(100) DEFAULT NULL, `RH` varchar(100) DEFAULT NULL, `TMP` varchar(100) DEFAULT NULL, `U` varchar(100) DEFAULT NULL, `V` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Thanks.