New to databases

[addictionInk]

I have to create a database for a school project and I am brand new to databases, is there a way to easily import this to access? Thank you for any guidance you can provide.

[daugaard47]

I can probably help you. Created an older website using this repo a few years back if I can find it, I'll shoot over the sql file.

[daugaard47]

Wait nevermind. They give you the most recent sql files. Simply import the file to your DB.

[addictionInk]

I'm new to Github too and haven't figured out how to download the file. When I click on it, it just opens, right click does not give me the option to download. Thank you for the help.

[daugaard47]

If you're not familiar with how to use the command line, simply click the green button where it says Clone or Download

1. Then download the zip. > Open the zip > Drag the files to your project folder called DB or whatever.
2. After that I'm assuming you're using PhpMyadmin:
3. Create a new Database... I.E. 'Cars'
4. Then copy and paste the schema.sql code in the SQL section of PhpMyadmin to create TABLE VehicleModelYear
5. Then import the data.sql file into your newly created Database. You can copy and past the SQL code to do this if needed
6. From there use php queries to calls to fetch the data from your Database.

Side note: you can run things much quicker if you learn Git. Here is a great tutorial to get you started:
Git-ing Started with Git

Hope that helps.