You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

17 lines
456 B

1 week ago
  1. #springboot
  2. SpringBoot Web, JPA, DevTools,MySQL, Freemarker, Bootstrap
  3. ```MySQL
  4. load data local infile 'f:\321.csv' into table importexcel fields terminated by '\t';
  5. insert into sku (sku_barcode, sku_name, sku_spec, sku_unit)
  6. select C2, C1, C5, C4 from importexcel
  7. ALTER TABLE `sku`
  8. DROP INDEX `sku_barcode`,
  9. ADD UNIQUE INDEX `sku_barcode` (`sku_barcode`);
  10. select sku_barcode,min(id) from sku group by sku_barcode having count(*) > 1
  11. ```