search

n8barr / automotive-model-year-data

Automotive data including vehicle model, make, and year for database creation
539 stars 320 forks source link

New to databases #31

Open addictionInk opened 6 years ago

addictionInk commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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

addictionInk commented 6 years ago

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 commented 6 years ago

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.