drop table if exists wufangzhai_caigou_group;

create table wufangzhai_caigou_group

(

   label VARCHAR(200) COLLATE utf8_bin,

   buyer_nick VARCHAR(200) COLLATE utf8_bin,

   name VARCHAR(200) COLLATE utf8_bin,

   mobile VARCHAR(200) COLLATE utf8_bin,

   address VARCHAR(200) COLLATE utf8_bin,

   detail VARCHAR(500) COLLATE utf8_bin

);

LOAD DATA LOCAL INFILE 'C:\wufangzhai_caigou_group.txt'

INTO TABLE wufangzhai_caigou_group

FIElDS TERMINATED BY ','

LINES TERMINATED BY '\n'

(label,buyer_nick,name,mobile,address,detail );