Question
How do you generate a python code to import the data from this Excel sheet into MySQL workbench? I only know some basics of Python
How do you generate a python code to import the data from this Excel sheet into MySQL workbench? I only know some basics of Python like print, list, operation. Really need some help on this one.
Note:
Schema: Testing
Tables: Tester, Gov, PrivateCompany
Tester table has columns: Login, Name, Email, Mobile
Gov table has columns: Gov_id, Gov_name
PrivateCompany table has columns: Private_id, Private_name
CPF, HDB, TP are attributes of Gov_name.
DBS, FairPrice are attribute of Private_name
We have two Excel file: Tester and GovPrivate, the screenshot is shown below:
Tester
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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