LOAD DATA LOCAL INFILE 'D:\\baidu\\Desktop\\aaa.csv'
INTO TABLE test.m CHARACTER SET GBK
FIELDS TERMINATED BY ',' ENCLOSED BY ''
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(gender,id);
如果有主键列和唯一列,则会根据唯一性约束排除重复值。
添加唯一性约束:ALTER table test.m add UNIQUE key1(gender,count);
删除唯一性约束:ALTER table test.m drop index key1;
唯一性约束=索引,主键=非空索引=非空唯一约束