CREATE TABLE names (
id SERIAL,
name TEXT NOT NULL
);
Then when I try to import a TSV file, the first few lines are...(id and name are separated by \t)
1 Barsotti, Marcel
2 Isamar Compania
3 Tradia
When I try to import via it gives me an error:
SQL Error (1366): Incorrect integer value: '1' for column 'id' at row 1
I have the import options configured as:
Fields terminated by \t
Lines terminated by \n
(I left the other two options blank)
Curiously I didn't have a problem with another table with the exact same id type
I've also tried changing the id type to INT instead of BIGINT