load data infile path into table tab_name 使用方式(注意path选择);
//导入cdkey;
AKDXVAAHmVDFSY
AKDXVAAHmVEHke
AKDXVAAHmVFsde

LOAD DATA LOCAL INFILE 'e:\MA201304_AK0' INTO TABLE tab_name;
create table tab_name(
tab_name varchar(50)
)engine=InnoDB charset=utf8;

SELECT CONCAT('''',tab_name,''',',65,',',1,',','''2013-4-22''',',','''2013-12-31''',',','''20130425105''',',')
FROM tab_name;
生成如下：
'AKDXVAAAAAAf',65,1,'2013-4-22','2013-12-31','20130425105',
'AKDXVAAAAABD',65,1,'2013-4-22','2013-12-31','20130425105',
'AKDXVAAAAADt',65,1,'2013-4-22','2013-12-31','20130425105',
'AKDXVAAAAAEj',65,1,'2013-4-22','2013-12-31','20130425105',

mysql -h ip -P port -u username -p passwd -e"
LOAD DATA LOCAL INFILE 'e:\data.sql' INTO TABLE tab_name
FIELDS TERMINATED BY ',' ENCLOSED by ''''
(tab_name,Package_Id,State,Active_Begin,Active_End,Block_Id);"

CREATE TABLE tab_name (
Id int(10) NOT NULL COMMENT '自增序列号',
tab_name varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '激活码',
Package_Id int(10) NOT NULL COMMENT '礼包Id',
State int(2) NOT NULL COMMENT 'cdkey状态[0：无效；1：可领取；2：领取中；3：已领取]',
Active_Begin timestamp NOT NULL DEFAULT '1980-01-01 00:00:00' COMMENT '有效期开始时间',
Active_End timestamp NOT NULL DEFAULT '1980-01-01 00:00:00' COMMENT '有效期结束时间',
Get_Timeout timestamp NOT NULL DEFAULT '1980-01-01 00:00:00' COMMENT '领取中超时时间',
Block_Id char(12) NOT NULL COMMENT '批次',
Get_Time timestamp NOT NULL DEFAULT '1980-01-01 00:00:00' COMMENT '领取时间',
Get_Role int(10) DEFAULT NULL COMMENT '领取人角色ID',
Insert_Time timestamp NOT NULL DEFAULT '1980-01-01 00:00:00' COMMENT '插入时间',
UNIQUE KEY Idx_key (cdkey),
KEY Idx_role (Get_Role)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='tab_name';

ITPub博客

load data ... infile table tab_name

最新文章