Добрый день! Не получается импортировать данные и текстового файла в таблицу. Все записи skipped. Смотрел warnings вылезло следующее:

Ввожу команду: mysql> load data local infile 'c:\\tmp\\milk1.txt' into table products;
Query OK, 0 rows affected, 105 warnings (0.00 sec)
Records: 21 Deleted: 0 Skipped: 21 Warnings: 105

вот что вывел show warnings; :

' for column 'product_id' at row 1 | value: '?product_id, name_product, quantity, shelf_life
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '0' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 2 |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '1' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 3 |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '2' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 4 |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '3' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 5 |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '4' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 6 |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '5' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 7 |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '6' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 8 |
| Warning | 1261 | Row 8 doesn't contain data for all columns |
| Warning | 1261 | Row 8 doesn't contain data for all columns |
| Warning | 1261 | Row 8 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '7' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 9 |
| Warning | 1261 | Row 9 doesn't contain data for all columns |
| Warning | 1261 | Row 9 doesn't contain data for all columns |
| Warning | 1261 | Row 9 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '8' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 10 |
| Warning | 1261 | Row 10 doesn't contain data for all columns |
| Warning | 1261 | Row 10 doesn't contain data for all columns |
| Warning | 1261 | Row 10 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '9' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 11 |
| Warning | 1261 | Row 11 doesn't contain data for all columns |
| Warning | 1261 | Row 11 doesn't contain data for all columns |
| Warning | 1261 | Row 11 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '10' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 12 |
| Warning | 1261 | Row 12 doesn't contain data for all columns |
| Warning | 1261 | Row 12 doesn't contain data for all columns |
| Warning | 1261 | Row 12 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '11' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 13 |
| Warning | 1261 | Row 13 doesn't contain data for all columns |
| Warning | 1261 | Row 13 doesn't contain data for all columns |
| Warning | 1261 | Row 13 doesn't contain data for all columns


Привожу содержание импортируемого файла:

name_product, quantity, shelf_date
'Кефир', '20', '2016-07-30'
'Молоко', '50', '2016-07-29'
'Сосиски', '12', '2016-08-12'
'Хлеб заводской', '36', '2016-07-27'
'Котлеты', '96', '2016-09-13'
'Творог', '60', '2016-07-30'
'Кумыс', '32', '2016-08-28'
'Сыр', '18', '2016-09-30'
'Сало', '203', '2016-09-30'
'Сметана', '60', '2016-08-22'
'Хлеб Семиреченский', '93', '2016-07-27'
'Булочка сдобная', '156', '2016-07-25'
'Пироженное картошка', '37', '2016-07-28'





Пробовал добавить в текстовый файл ID (хотя по логике должно само присваиваться)

Содержание файла с ID:

product_id, name_product, quantity, shelf_life
1, "Кефир", 20, 2016-07-30
2, "Молоко", 50, 2016-07-25
3, "Сосиски", 12, 2016-08-12
4, "Хлеб заводской", 36, 2016-07-27
5, "Котлеты", 96, 2016-09-13
6,"Творог", 60, 2016-07-23
7, "Кумыс", 32, 2016-08-28
8, "Сыр", 18, 2016-09-30
9, "Сало", 203, 2016-09-30
10, "Сметана", 60, 2016-07-22
11, "Хлеб Семиреченский", 93, 2016-07-27
12, "Булочка сдобная", 156, 2016-07-25
13, "Пироженное картошка", 37, 2016-07-22


Вот результат команды:

load data local infile 'c:\\tmp\\milk1.txt' into table products;
Query OK, 0 rows affected, 105 warnings (0.00 sec)
Records: 21 Deleted: 0 Skipped: 21 Warnings: 105


Вот что выводит команда show warnings; :

mysql> show warnings;
+---------+------+--------------------------------------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------------------------------------------------------------------------+
' for column 'product_id' at row 1 | value: '?product_id, name_product, quantity, shelf_life
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1261 | Row 1 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '0' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 2 |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1261 | Row 2 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '1' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 3 |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1261 | Row 3 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '2' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 4 |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1261 | Row 4 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '3' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 5 |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1261 | Row 5 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '4' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 6 |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1261 | Row 6 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '5' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 7 |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
| Warning | 1261 | Row 7 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '6' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 8 |
| Warning | 1261 | Row 8 doesn't contain data for all columns |
| Warning | 1261 | Row 8 doesn't contain data for all columns |
| Warning | 1261 | Row 8 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '7' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 9 |
| Warning | 1261 | Row 9 doesn't contain data for all columns |
| Warning | 1261 | Row 9 doesn't contain data for all columns |
| Warning | 1261 | Row 9 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '8' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 10 |
| Warning | 1261 | Row 10 doesn't contain data for all columns |
| Warning | 1261 | Row 10 doesn't contain data for all columns |
| Warning | 1261 | Row 10 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '9' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 11 |
| Warning | 1261 | Row 11 doesn't contain data for all columns |
| Warning | 1261 | Row 11 doesn't contain data for all columns |
| Warning | 1261 | Row 11 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '10' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 12 |
| Warning | 1261 | Row 12 doesn't contain data for all columns |
| Warning | 1261 | Row 12 doesn't contain data for all columns |
| Warning | 1261 | Row 12 doesn't contain data for all columns |
| Warning | 1062 | Duplicate entry '11' for key 'PRIMARY' |
| Warning | 1265 | Data truncated for column 'product_id' at row 13 |
| Warning | 1261 | Row 13 doesn't contain data for all columns |
| Warning | 1261 | Row 13 doesn't contain data for all columns |
| Warning | 1261 | Row 13 doesn't contain data for all columns |
+---------+------+--------------------------------------------------------------------------------------------------------------+
64 rows in set (0.00 sec)



База пустая :


mysql> describe products;
+--------------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------+------+-----+---------+-------+
| product_id | int(11) | NO | PRI | NULL | |
| name_product | text | YES | | NULL | |
| quantity | int(11) | YES | | NULL | |
| shelf_life | date | YES | | NULL | |
+--------------+---------+------+-----+---------+-------+
4 rows in set (0.00 sec)





Пните пожалуйста куда копать в чем загвоздка, только сильно не пинайте я взял задание на вакансию java junior и там по требованию нужно создать таблицы, наполнить их и написать запросы, MySQL изучал пару часов.

Заранее спасибо!