MySQL Database Creation from CSV
Budget: $10 – $30 USD
I'm looking for a professional who can help me set up a MySQL database on my local machine using phpMyAdmin and Workbench. The source of the data will be a CSV file I provide which has 4 columns and approximately 200,000 lines.
Once set perform a SQL query to filter results to select one field being present in several dates.
Key Requirements:
- Import the CSV file into a single table
- Set up a primary key for the table
Skills & Experience:
- Proficient in MySQL, phpMyAdmin, and Workbench
- Experience with handling large datasets
- Good understanding of database structuring
Please note, the data does not require any pre-import processing or cleaning. It should be imported as is, into a single table containing all the data. Only a primary key is needed for this project, no foreign keys or additional indexing are required.
Once set perform a SQL query to filter results to select one field being present in several dates.
Key Requirements:
- Import the CSV file into a single table
- Set up a primary key for the table
Skills & Experience:
- Proficient in MySQL, phpMyAdmin, and Workbench
- Experience with handling large datasets
- Good understanding of database structuring
Please note, the data does not require any pre-import processing or cleaning. It should be imported as is, into a single table containing all the data. Only a primary key is needed for this project, no foreign keys or additional indexing are required.