Getting an error in IMPORT from csv file.
Lets say I have a csv that is 2 fields:
Following the instructions from the site:
IMPORT TABLE customers (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
INDEX name_idx (name)
CSV DATA (–my local http file server–)
nullif = ‘’
I get a SQL error: Expected 3 fields, got 2.
The id field, which I am asking CDRB to create as a UUID plus the 2 fields from the file give this error.
Help would be most welcome!