Question: answer the above and then help me to Link it to my GitHub repository. Create a new file under the module_8 directory and name it
answer the above and then help me to Link it to my GitHub repository.
Create a new file under the module_8 directory and name it pysports_queries.py. Write the code to connect to your MySQL pysports database. Refer to the previous assignment for code structure. You can basically copy/paste the code we used in the previous assignment, assuming you were able to get it to work. Write two select queries, one for the team table and one for the player table. . SELECT team_id, team_name, mascot FROM team. Using a for loop, iterate over the cursor and display the results. Make sure your output matches the expected output below (this is gradable).
Step by Step Solution
3.45 Rating (158 Votes )
There are 3 Steps involved in it
To fulfill the requirements of your assignment you need to create a Python script that connects to your MySQL database performs the SELECT queries and ... View full answer
Get step-by-step solutions from verified subject matter experts
