samedi 23 avril 2016

Database Assignment

I'm supposed to upload a database for an assignment, but I'm having a problem. These are the instructions:

"This application will read the mailbox data (mbox.txt) count up the number email messages per organization (i.e. domain name of the email address) using a database with the following schema to maintain the counts.

CREATE TABLE Counts (org TEXT, count INTEGER) When you have run the program on mbox.txt upload the resulting database file above for grading. If you run the program multiple times in testing or with different files, make sure to empty out the data before each run.

You can use this code as a starting point for your application: [http://ift.tt/1YN02aT].

The data file for this application is the same as in previous assignments: http://ift.tt/1OhbzyH.

Because the sample code is using an UPDATE statement and committing the results to the database as each record is read in the loop, it might take as long as a few minutes to process all the data. The commit insists on completely writing all the data to disk every time it is called."

The SQL code that I entered was

The error message that it keeps sending me is that my "Data is Incorrect".

Can anybody help with this?

Aucun commentaire:

Enregistrer un commentaire