import mysql.connector
 
# Connect to MySQL database
conn = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="SELECTION_DB"
)
 
# Create cursor
cursor = conn.cursor()
 
# Create table EMP_SELECTION if not exists
create_table_query = """
CREATE TABLE IF NOT EXISTS EMP_SELECTION (
    FIRST_NAME VARCHAR(255),
    LAST_NAME VARCHAR(255),
    AGE INT,
    GENDER VARCHAR(1),
    INCOME DECIMAL(10, 2)
)
"""
cursor.execute(create_table_query)
 
# Add a column 'address' to the table EMP_SELECTION
alter_table_query = """
ALTER TABLE EMP_SELECTION
ADD COLUMN address VARCHAR(255)
"""
cursor.execute(alter_table_query)
 
# Insert a record into EMP_SELECTION table
insert_query = """
INSERT INTO EMP_SELECTION (FIRST_NAME, LAST_NAME, AGE, GENDER, INCOME, address)
VALUES (%s, %s, %s, %s, %s, %s)
"""
record = ("John", "Doe", 25, "M", 50000.00, "123 Street")
cursor.execute(insert_query, record)
 
# Commit changes to the database
conn.commit()
 
# Update records where GENDER is 'M' and increase AGE by one year
update_query = """
UPDATE EMP_SELECTION
SET AGE = AGE + 1
WHERE GENDER = 'M'
"""
cursor.execute(update_query)
conn.commit()
 
# Delete records where AGE is less than 18
delete_query = """
DELETE FROM EMP_SELECTION
WHERE AGE < 18
"""
cursor.execute(delete_query)
conn.commit()
 
# Close cursor and connection
cursor.close()
conn.close()
 

aW1wb3J0IG15c3FsLmNvbm5lY3RvcgoKIyBDb25uZWN0IHRvIE15U1FMIGRhdGFiYXNlCmNvbm4gPSBteXNxbC5jb25uZWN0b3IuY29ubmVjdCgKICAgIGhvc3Q9ImxvY2FsaG9zdCIsCiAgICB1c2VyPSJ5b3VyX3VzZXJuYW1lIiwKICAgIHBhc3N3b3JkPSJ5b3VyX3Bhc3N3b3JkIiwKICAgIGRhdGFiYXNlPSJTRUxFQ1RJT05fREIiCikKCiMgQ3JlYXRlIGN1cnNvcgpjdXJzb3IgPSBjb25uLmN1cnNvcigpCgojIENyZWF0ZSB0YWJsZSBFTVBfU0VMRUNUSU9OIGlmIG5vdCBleGlzdHMKY3JlYXRlX3RhYmxlX3F1ZXJ5ID0gIiIiCkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIEVNUF9TRUxFQ1RJT04gKAogICAgRklSU1RfTkFNRSBWQVJDSEFSKDI1NSksCiAgICBMQVNUX05BTUUgVkFSQ0hBUigyNTUpLAogICAgQUdFIElOVCwKICAgIEdFTkRFUiBWQVJDSEFSKDEpLAogICAgSU5DT01FIERFQ0lNQUwoMTAsIDIpCikKIiIiCmN1cnNvci5leGVjdXRlKGNyZWF0ZV90YWJsZV9xdWVyeSkKCiMgQWRkIGEgY29sdW1uICdhZGRyZXNzJyB0byB0aGUgdGFibGUgRU1QX1NFTEVDVElPTgphbHRlcl90YWJsZV9xdWVyeSA9ICIiIgpBTFRFUiBUQUJMRSBFTVBfU0VMRUNUSU9OCkFERCBDT0xVTU4gYWRkcmVzcyBWQVJDSEFSKDI1NSkKIiIiCmN1cnNvci5leGVjdXRlKGFsdGVyX3RhYmxlX3F1ZXJ5KQoKIyBJbnNlcnQgYSByZWNvcmQgaW50byBFTVBfU0VMRUNUSU9OIHRhYmxlCmluc2VydF9xdWVyeSA9ICIiIgpJTlNFUlQgSU5UTyBFTVBfU0VMRUNUSU9OIChGSVJTVF9OQU1FLCBMQVNUX05BTUUsIEFHRSwgR0VOREVSLCBJTkNPTUUsIGFkZHJlc3MpClZBTFVFUyAoJXMsICVzLCAlcywgJXMsICVzLCAlcykKIiIiCnJlY29yZCA9ICgiSm9obiIsICJEb2UiLCAyNSwgIk0iLCA1MDAwMC4wMCwgIjEyMyBTdHJlZXQiKQpjdXJzb3IuZXhlY3V0ZShpbnNlcnRfcXVlcnksIHJlY29yZCkKCiMgQ29tbWl0IGNoYW5nZXMgdG8gdGhlIGRhdGFiYXNlCmNvbm4uY29tbWl0KCkKCiMgVXBkYXRlIHJlY29yZHMgd2hlcmUgR0VOREVSIGlzICdNJyBhbmQgaW5jcmVhc2UgQUdFIGJ5IG9uZSB5ZWFyCnVwZGF0ZV9xdWVyeSA9ICIiIgpVUERBVEUgRU1QX1NFTEVDVElPTgpTRVQgQUdFID0gQUdFICsgMQpXSEVSRSBHRU5ERVIgPSAnTScKIiIiCmN1cnNvci5leGVjdXRlKHVwZGF0ZV9xdWVyeSkKY29ubi5jb21taXQoKQoKIyBEZWxldGUgcmVjb3JkcyB3aGVyZSBBR0UgaXMgbGVzcyB0aGFuIDE4CmRlbGV0ZV9xdWVyeSA9ICIiIgpERUxFVEUgRlJPTSBFTVBfU0VMRUNUSU9OCldIRVJFIEFHRSA8IDE4CiIiIgpjdXJzb3IuZXhlY3V0ZShkZWxldGVfcXVlcnkpCmNvbm4uY29tbWl0KCkKCiMgQ2xvc2UgY3Vyc29yIGFuZCBjb25uZWN0aW9uCmN1cnNvci5jbG9zZSgpCmNvbm4uY2xvc2UoKQo=