学习记录十

1.复习昨天的数据处理及数据类型

 

2.mysql中导入本地文件.TXT.csv

 

 

①SHOW GLOBAL VARIABLES LIKE'chy';

 

②SET GLOBAL chy=true;

(本地文件先把名字改为英文，编码改为utf8)

 

③CREATE TABLE chy (字段)

 

④LOAD DATA LOCAL INFILE"路径" INTO TABLE chy FIELDS TERMINATED BY ' ' IGNORE 1 LINES;

 

⑤SELECT (加一些字段)

INTO OUTFILE(路径)

FROM chy;

DELETE FROM chy;