mysql 导出导入数据示例

LOAD DATA LOCAL INFILE "C:/地址/文档.txt" 
-- 导入表 
IGNORE INTO TABLE tbl_bind_ip 
-- 编辑字符编码
CHARACTER SET UTF8  
-- 字段用 | 进行分隔
FIELDS TERMINATED BY '|' 
ENCLOSED BY '"' LINES TERMINATED BY '\r\n'(`uuid`, `user_id`, `bind_ip`);

 

//表结构

CREATE TABLE `tbl_bind_ip` (
  `uuid` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) DEFAULT NULL,
  `bind_ip` char(20) DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  UNIQUE KEY `UQE_tbl_bind_ip_bind_ip` (`bind_ip`)
) ENGINE=InnoDB AUTO_INCREMENT=4830 DEFAULT CHARSET=utf8

// 格式

"172"|"270"|"112.74.132.156"
"175"|"426"|"117.173.191.10"

参考

https://dev.mysql.com/doc/refman/5.7/en/load-data.html