CBSE 2025, Compartment, Set 4

Question

Nutan Kumar is using Python connectivity with MySQL for maintaining data for a table named `MEDICINES` in a database `PHARMACY`. The table has the following attributes:
- `MId` (Medicine number) : string
- `Mname` (Medicine Name) : string
- `Expiry` (Expiry Date) : Date
- `Status` (Active/Discard) : string

Consider the following to establish connectivity between Python and MySQL:
- Username: root
- Password: tiger
- Host: localhost

Help Nutan to write the definition of a user-defined function named `ChangeStatus()` in Python to change the Status of the Medicines whose Expiry is before "2022-12-31" as "DISCARD".

Edvaya · Accepted Answer

The correct answer is Subjective. ```python import mysql.connector def ChangeStatus(): try: # Establish connection with the MySQL database conn = mysql.connector.connect( host="localhost", user="root", password="tiger", database="PHARMACY" ) # Create a cursor object cursor = conn.cursor() # SQL Query to update the status update_query = "UPDATE MEDICINES SET Status = \"DISCARD\" WHERE Expiry < \"2022-12-31\";" # Execute the query cursor.execute(update_query) # Commit the transaction conn.commit() print(cursor.rowcount, "record(s) updated successfully.") except mysql.connector.Error as err: print("Database Connection Error:", err) finally: # Close the cursor and connection safely if conn.is_connected(): cursor.close() conn.close() ```

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Computer Science > Database Management > Interface Of Python With Sql

Keep Practicing

Current Question

Community Stats

Track Your Progress

Edvaya Target

We Value Your Privacy