Database I don\'t know this question. Can you please tell me why it does that..

Question

Database I don't know this question. Can you please tell me why it does that.. Pages File Edit IHSult FUIllut CSCI 4333 Assignment 8 Data Import and DML() 2 Edited all T 125%v ST v Insert Table Chart Text shape Media Comment collaborate Format Doc CSCI 4333 Assignment 8 Spring 2017 Data Integrity and SQL DML Section 1. Data Integrity As we have observed in the class the slsenup ss data file, which contains the sales employee data for the organization has 988 records. When imported this data to Sales Reporting MySQL Database, we observed that only 939 records were inserted successfully. We the same issue with sstratw.csy file. This file contains 382 records, but only 379 records were inserted successfully. Please explain the reason(s) for these discrepancies. Note: We have imported the .csy file ase study in 3/29/2017 class. 584 words The source sv files and DDL code to build thus database is located on Blackboard at the

Explanation / Answer

So, here we are inserting a CSV data file into a delimited database like MySQL. TO perform this task, LOAD DATA INFILE statement is used, which is used to insert data in the table.

There are some reasons as to why not all rows are being inserted with this.

First can be that the datat file is not formatted properly. This means that maybe, in some records, extra double quotes are used, or maybe that the column sequence in table and the datat file are different.

Another reason can be that there might be some conflicting records, where primary key is given same, but they are two different records. So, in this case, only one record is considered and others are skipped.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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