importing csv into phpmyadmin #1062 - Duplicate entry '5000'
Posted: Wed Jan 27, 2016 1:42 pm
i have an excel spreadsheets that i have converted into a csv file here is the first line of the exported file
[text]5000,"Sleeveless Suit, Inky Black, Heart Hands",Made from 100% quality Cotton fabric ... Clothes are Unisex which are made to be mixed and matched ,31,0,sleeveless romper black hands.jpg,,,58,0,0,0,SS16,0,0
[/text]
but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there.
the settings i am using are
import
select the csv file
Character set of the file:utf-8
Columns separated with:,
Columns enclosed with:"
Columns escaped with:"
Lines terminated with:auto
Do not abort on INSERT error (not ticked)
[text]5000,"Sleeveless Suit, Inky Black, Heart Hands",Made from 100% quality Cotton fabric ... Clothes are Unisex which are made to be mixed and matched ,31,0,sleeveless romper black hands.jpg,,,58,0,0,0,SS16,0,0
[/text]
but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there.
the settings i am using are
import
select the csv file
Character set of the file:utf-8
Columns separated with:,
Columns enclosed with:"
Columns escaped with:"
Lines terminated with:auto
Do not abort on INSERT error (not ticked)