CREATE TABLE assets (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
type VARCHAR(100),
purchase_date DATE,
status ENUM('active', 'inactive') DEFAULT 'active'
);
]]>
import mysql.connector
def add_asset(name, asset_type, purchase_date):
conn = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="asset_management"
)
cursor = conn.cursor()
query = "INSERT INTO assets (name, type, purchase_date) VALUES (%s, %s, %s)"
values = (name, asset_type, purchase_date)
cursor.execute(query, values)
conn.commit()
print(f"Asset {name} added successfully.")
cursor.close()
conn.close()
add_asset("Laptop", "Electronics", "2023-09-15")
]]>
