load data ... infile table tab_name

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博客 ” ，链接：http://blog.itpub.net/26855487/viewspace-759110/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26855487/viewspace-759110/