MySQL Forums
Forum List  »  MySQL Workbench

import tab delimited file with SET column data
Posted by: Ken Gillett
Date: June 16, 2019 12:34PM

Doesn't work.

I've imported several simple files ok, but this table has 3 columns, the last being a SET type. Using the data import wizard it would proceed apparently perfectly, but nothing was imported. When I checked more closely there was a flash of something in the import wizard window but too fast to see. However the logs said data for that column had to be truncated so every line failed. Utter nonsense of course as I was able to insert the same data directly with SQL.

So yet again, WB is unable to follow my simple workflow. It writes incorrect SQL code when sync'ing to the server and now is unable to import data into a table it created. So comprehensive on the surface, but oh so terribly flawed.

Or is there a special and secret way to import data into a SET type column?

Options: ReplyQuote


Subject
Views
Written By
Posted
import tab delimited file with SET column data
169
June 16, 2019 12:34PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.