Suq5tArd

1inserting data in mysql by text file
2CREATE TABLE IF NOT EXISTS `jos_lat_log` (
3`Lat` text NOT NULL,
4`Lon` varchar(255) NOT NULL,
5`climatefamily` varchar(255) NOT NULL
6);
7	
8CREATE TABLE IF NOT EXISTS `jos_lat_log` (
9`Lat` text NOT NULL,
10`Lon` varchar(255) NOT NULL,
11`climatefamily` varchar(255) NOT NULL
12);
13	
14LOAD DATA LOCAL INFILE 'C:\Koeppen-Geiger-ASCII.txt' 
15INTO TABLE `jos_lat_log` FIELDS TERMINATED BY '' LINES TERMINATED BY 'rn';
16	
17TERMINATED BY ' '