mysql5.7数据导入脚本

-- q


show variables like '%secure%';

SHOW VARIABLES LIKE '%local%';

drop table xxx 

LOAD DATA local INFILE 'E:\\xxxxx.txt' IGNORE
INTO TABLE xxx
FIELDS terminated by '----'
lines terminated by '\n'(qq,phone);


select * from xxx


--w

drop table xxx 

CREATE TABLE `xxx` (
  `phone` bigint DEFAULT NULL,
  `uid` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1


LOAD DATA local INFILE 'E:\\SGK/SGK1/xxxxx.txt' IGNORE
INTO TABLE xxx
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'(phone,uid)