//使用文件的方式处理大批量数据,插入数据库
--导出数据到文件
SELECT id,user_id,vote_id,group_id,create_time INTO OUTFILE 'F:/result1.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM vote_record_memory;
--加载文件数据
LOAD DATA LOCAL INFILE 'F:/result1.txt' INTO TABLE vote_record
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(id,user_id,vote_id,group_id,create_time)