Scribd
Upload
4 views1 page

Revised Python MySQL Questions

The document outlines four tasks involving MySQL databases and Python programming. It includes instructions for inserting, updating, deleting, and displaying records in various tables across different databases (HospitalDB, OfficeDB, SchoolDB, and BankDB) using specified credentials. Each task requires establishing a connection to the respective database before performing the operations.

Uploaded by

Sangeetha Kamalakannan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

Revised Python MySQL Questions

The document outlines four tasks involving MySQL databases and Python programming. It includes instructions for inserting, updating, deleting, and displaying records in various tables across different databases (HospitalDB, OfficeDB, SchoolDB, and BankDB) using specified credentials. Each task requires establishing a connection to the respective database before performing the operations.

Uploaded by

Sangeetha Kamalakannan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1. A MySQL database named HospitalDB has a table CarePatients.

Enter Patient ID, Patient Name, Doctor and Status. Write a Python program to insert the
entered values into the CarePatients table after establishing Python-MySQL
connectivity using: Username: root Password: admin123 Host: localhost
2. A MySQL database named OfficeDB has a table EMP_Details.
Enter Employee ID and new Status. Write a Python program to update the status of the
given employee in the EMP_Details table after establishing Python-MySQL connectivity
using: Username: hr_admin Password: office@2024 Host:[Link]
3. A MySQL database named SchoolDB has a table StudentRecords.
Enter the Roll Number. Write a Python program to delete the corresponding record
from the StudentRecords table after establishing Python-MySQL connectivity using:
Username: schooladmin Password: Bright$chool99 Host: [Link]
4. A MySQL database named BankDB has a table CustAccounts.
Enter the Account Status. Write a Python program to display all customer details
having the entered status from the CustAccounts table after establishing
Python-MySQL connectivity using: Username: bankuser Password: Secure#Bank7
Host:[Link]

You might also like