GitHub - DarryQueen/CSV-to-Database: First attempt at SQL. Takes a CSV with employee fields and converts them to a database. Also includes some sample queries.

DarryQueen / CSV-to-Database Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

First attempt at SQL. Takes a CSV with employee fields and converts them to a database. Also includes some sample queries.

0 stars 0 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
CSVParser.java		CSVParser.java
Employees.csv		Employees.csv
README		README
insert_commands.sql		insert_commands.sql
queries.sql		queries.sql
schema.sql		schema.sql

Repository files navigation

System that parses through CSV, converts it into INSERT statements, and runs quick queries through the statements.

CSVParser.java:		Contains source code for CSV parser, reads input from Employees.csv and outputs a file insert_commands.sql with corresponding INSERT statements.
insert_commands.sql: 	Necessary INSERT statements from Employees.csv.
schema.sql: 		Schema statements for table.
queries.sql:		Some query statements.