-- 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)
mysql5.7数据导入脚本
于 2022-07-16 20:15:08 首次发布