I\'m just having problem with importing the csv file into mysql workbench. it ju

Question

I'm just having problem with importing the csv file into mysql workbench. it just import 0 records.

csv file:

workbench:

1 DROP DATABASE IF EXISTS w6_finalexams; 2 CREATE DATABASE w6_finalexams; 3 USE w6_finalexams; 4 5 CREATE TABLE adjudicator adjudicatorID INT UNIQUE, adjudicatorName VARCHAR (60), PRIMARY KEY (adjudicatorID) 7 10 11 CREATE TABLE exam ( 12 13 14 15 16 17 18 19 20; 21 22 CREATE TABLE student 23 24 25 26 27 28 29 30 examID INT AUTOINCREMENT name VARCHAR (60), location VARCHAR (255) NOT NULL dateANDtime DATETIME NOT NULL adjudicatorID INT, adjudicatorName VARCHAR (60), PRIMARY KEY (examID), FOREIGN KEY (adjudicatorID) REFERENCES adjudicator (adjudicatorID) studentID INT AUTO_INCREMENT firstName varchar(30), LastName varchar(30), grade char(2), examID INT, PRIMARY KEY (studentID), FOREIGN KEY (examID) REFERENCES exam (examID)

Explanation / Answer

Steps to correct out the error.

1) Try changing the file encoding at Configure Import Setting from UTF-8 to cp1250 and then perform the import.

2) If not successful in step 1 then try importing first fewer line of data from excel and then gradually increase until you find the erroneous record.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.