创建表
CREATE TABLE IF NOT EXISTS `uid_pcode`(
`uid` bigint,
`pcode` VARCHAR(32) NOT NULL,
PRIMARY KEY ( `uid` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
/mnt/data1/uid_phone.txt
文件内容格式如下
1 13888888888
即:uid\t
phone\n
需要对phone对称加密后存储到pcode里
mysql -uroot -p
mysql> LOAD DATA INFILE '/mnt/data1/uid_phone.txt' IGNORE INTO TABLE uid_pcode(@c1,@c2)
set uid=@c1,pcode=HEX(aes_encrypt(lower(conv(@c2,10,32)),'yourkey'));
数据量大的话比较慢,可以通过nohup
命令运行
转载请联系:宋洋葱
参考文献: