JAVA on the way

1.java的程序代码分为两大类：

1）结构定义语句；

2）功能执行语句。

e:

class Lesson2 //结构定义语句{    public static void main(String[] args)  //结构定义语句    {        System.out.println("Hello world!");  //功能执行语句    }}

_______________我是华丽的分界线________________

如何从文件(excel、txt)导入数据到mysql

正常utf-8字符集：

load data local infile '~/Desktop/firstCountryBook.txt' into table rl_country fields terminated by '\t' ;

非utf-8：

load data local infile '~/Desktop/firstCountryBook.txt' into table rl_country fields terminated by '\t' lines terminated by '\r\n';

load data local infile '~/Desktop/firstCountryBook.txt' into table rl_country fields terminated by '\t' lines terminated by '\r';

gutao987$ head ~/Desktop/firstCountryBook.txt1安道尔AndorraAD2阿拉伯联合酋长国United Arab EmiratesAE3阿富汗AfghanistanAF4安提瓜AntiguaAG5安圭拉AnguillaAI6阿尔巴尼亚AlbaniaAL7亚美尼亚ArmeniaAM8荷属安的列斯群岛Netherland antilliesAN9安哥拉AngolaAO10阿根廷ArgentinaAR