Dima T,

Ругается на строках где в конце есть табуляция.

C:\77777777777>ean2sqlite.cmd
Could Not Find C:\77777777777\ean.db
off
import uhtt_barcode_ref_all.csv ...
uhtt_barcode_ref_all.csv:1643688: expected 7 columns but found 3 - filling the rest with NULL
uhtt_barcode_ref_all.csv:1643689: expected 7 columns but found 5 - filling the rest with NULL
uhtt_barcode_ref_all.csv:1870051: expected 7 columns but found 3 - filling the rest with NULL
uhtt_barcode_ref_all.csv:1870052: expected 7 columns but found 5 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2050294: expected 7 columns but found 3 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2050295: expected 7 columns but found 5 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2050311: expected 7 columns but found 3 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2050312: expected 7 columns but found 5 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2050339: expected 7 columns but found 3 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2050340: expected 7 columns but found 5 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2050342: expected 7 columns but found 3 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2050343: expected 7 columns but found 5 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2423876: expected 7 columns but found 3 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2423877: expected 7 columns but found 5 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2897445: expected 7 columns but found 3 - filling the rest with NULL
uhtt_barcode_ref_all.csv:2897446: expected 7 columns but found 5 - filling the rest with NULL
delete wrong
set NULL
create Category
rows
2275
create Brand
rows
36009
create EAN
rows
2922766
vacuum

Dima T,

тут уникальные индексы должны быть
echo create unique index category_category_idx ON category(category); >> create.sql
echo create unique index brand_brand_idx ON brand(brand); >> create.sql

а этот можно выкинуть
echo create index ean_tovar_idx ON ean(tovar); >> create.sql

ведь искать будут like '%бла-бла-бла%'?
и размер становится 335 Мб.