The conceptual process of populating related tables in a database (MySql) from a CSV file
- by user322772
I'm new to relational databases and all the material I've read covered primary and foreign keys, normal forms, and joins but left out to populate the database once it's created.
How do you import a CSV file so the fields match their related table?
Say you were tying to build a beer database and had a CSV file with each line as a record.
Header: brewer, beer_name, country,
city, state, beer_category, beer_type,
alcohol_content
Record 1: Anheuser-Busch, Budweiser,
United States, St. Louis, Mo, Pale lager,
Regular,
5.0%
Record 2: Anheuser-Busch, Bud Light,
United States, St. Louis, Mo, Pale lager
Light, 4.2%
Record 3: Miller Brewing Company,
Miller Lite, United States, Milwaukee,
WI, Pale lager, Light,
4.2%
You can create a "Brewer" table and a "Beer" table. When importing how does you connect the primary keys between the tables?
