I need to load file content into a table. The file contains text separated by commas. It is a very large file. I can not change the file it is already given to me like this.

```
12.com,128.15.8.6,TEXT1,no1,['128.15.8.6']
23com,122.14.10.7,TEXT2,no2,['122.14.10.7']
45.com,91.33.10.4,TEXT3,no3,['91.33.10.4']
67.com,88.22.88.8,TEXT4,no4,['88.22.88.8', '5.112.1.10']

```

I need to load the file into a table of four columns. So for example, the last row above should be in the table as follows:

**table.col1:** 67.com

**table.col2:** 88.22.88.8

**table.col3:** TEXT3

**table.col4:** no3

**table.col5:** ['88.22.88.8', '5.112.1.10']

Using MySQL workbench, I created a table with five columns all are of type `varchar`. Then I run the following SQL command:

```
LOAD DATA INFILE '/var/lib/mysql-files/myfile.txt'
  INTO TABLE `mytable`.`myscheme`
  fields terminated BY ','

```

The last column string (which contains commas that I do not want to separate) causes an issue.

```
Error:
Error Code: 1262. Row 4 was truncated; it contained more data than there were input columns

```

How can I overcome this problem please.