建库:
create database jeremy;
use jeremy;
建表:
create table t1( id int, name String, sex String) row format delimited fields terminated by '\t';
创建一个表字段以制表符为分隔符的t1表,字段分别有整形字段id,字符型字段name,字符型字段sex.
delimited:界定. de-:加强,强调 ,前缀. limit:界限. -ed:动词过去分词或形容词后缀.
terminated:终止,终结,结束. termin-:边界 -ate:形容词后缀. -ed:动词过去分词后缀