Question

Write a function Delete_Theatre() to input the value of Th_ID from the user and permanently delete the corresponding record from the THEATRE table in the CINEMA database.

Given:
Host: localhost, User: root, Password: Ex2025

Hint:

Always use commit() after INSERT, UPDATE, or DELETE to save changes.
Use cursor.rowcount to check if a record was modified or deleted.
For security and reliability, use parameterized queries like %s to avoid SQL injection.

Answer 1

Python Function:

Code:
import mysql.connector
def Delete_Theatre():
    try:
        mydb = mysql.connector.connect(
            host="localhost",
            user="root",
            passwd="Ex2025",
            database="CINEMA"
        )
        mycursor = mydb.cursor()

        thid = input("Enter Theatre ID to delete: ")
        query = "DELETE FROM THEATRE WHERE Th_ID = %s"
        mycursor.execute(query, (thid,))
        mydb.commit()

        if mycursor.rowcount > 0:
            print("Record deleted successfully.")
        else:
            print("No record found with the given Theatre ID.")

        mycursor.close()
        mydb.close()
    except mysql.connector.Error as err:
        print("Error:", err)


Explanation:
- Connects to the CINEMA database.
- Deletes a record from THEATRE where Th_ID matches user input.
- Commits the change and checks for success.
- Displays an error message if the operation fails.