Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started