Re: Importing .csv into MySQL table
> Error1062:Duplicate entry '0' for key 'PRIMARY'
That is, you already ran the .csv file, and are now asking mysql to insert a primary key value that already exists in the table.
Remind your boss that using an RDBMS isn't like riding a bicycle. It requires basic knowledge. If you're "to learn how to create tables and populate them", you'll meed to start by studying the basics of relational databases, then working through some tutorials including those in the first chapters of the 5.5 manual.
Subject
Written By
Posted
Re: Importing .csv into MySQL table
January 21, 2019 02:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.