importing csv into phpmyadmin #1062 - Duplicate entry '5000'

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jonnyfortis
Forum Contributor
Posts: 462
Joined: Tue Jan 10, 2012 6:05 am

importing csv into phpmyadmin #1062 - Duplicate entry '5000'

Post by jonnyfortis »

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)
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: importing csv into phpmyadmin #1062 - Duplicate entry '5

Post by Celauran »

jonnyfortis wrote:but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there
Have you checked that the row isn't duplicated in your CSV?
jonnyfortis
Forum Contributor
Posts: 462
Joined: Tue Jan 10, 2012 6:05 am

Re: importing csv into phpmyadmin #1062 - Duplicate entry '5

Post by jonnyfortis »

Celauran wrote:
jonnyfortis wrote:but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there
Have you checked that the row isn't duplicated in your CSV?
yes sorry one had sneaked in there. sorry about that
Post Reply