#springboot

SpringBoot Web, JPA, DevTools,MySQL, Freemarker, Bootstrap

load data local infile 'f:\321.csv' into table importexcel fields terminated by '\t';

insert into sku (sku_barcode, sku_name, sku_spec, sku_unit) 
select C2, C1, C5, C4  from importexcel
 
ALTER TABLE `sku`
 	DROP INDEX `sku_barcode`,
 	ADD UNIQUE INDEX `sku_barcode` (`sku_barcode`);
 	
select sku_barcode,min(id) from sku group by sku_barcode having count(*) > 1