All Questions
5 questions
1
vote
1
answer
123
views
Upgrading from excel to an actual database
Just started my first internship and I could use some guidance on approaching the project given to me. Simply put, all that needs to be done is to make a database and then transfer the data from a ...
- 11
0
votes
3
answers
3k
views
Extracting data from extremely large csv files [closed]
I have a 40gb csv file with over 60 million rows for data analysis. Each row has a unique identifier (some numbers). For example, the first row's unique identifier will repeat approximately 150,000 ...
2
votes
1
answer
17k
views
Correct 'lines terminated by' for query
I am trying to query two tables of data and send them to a csv file for upload to a website. However i am having trouble getting the formatting to play ball. I want headings to separate into columns ...
- 133
0
votes
1
answer
67
views
Export database in one file with every dataset existing
I've got a unusual question.
The human resources needs to export an old DB to a new one.
And the guys managing the new DB wants one csv file with every dataset existing.
I did a Relational database ...
- 123
3
votes
2
answers
2k
views
Excel Spreadsheet Import to MySQL
I want to add about 1000 records to a table that contains 31 fields.
The worst part is those 1000 records are in the form of an excel sheet having some columns left unfilled. Is there any easy way to ...
- 31