From a file in excel I generate a csv file which I want to import into PhpMyAdmin using the Import from PhpMyAdmin option. But the first field, which is the primary key, only recognizes the last 3 characters.
INSERT INTO 'tabla' VALUES ('214', '90', '2', '1', '201802', '2018-01-11'...)
The original record is this:
21214 90 2 1 20182 2018-01-11
And the first field is int (10) unsigned. When I generate the csv, I open it with Notepad and record it with UTF-8 encoding. When I worked with office 2010 I had no problem, now I use office 2016 and I have this problem.