CREATE TABLE Project (
project_id INT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(255),
start_date DATE,
end_date DATE
);
CREATE TABLE Personnel (
personnel_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100),
role ENUM('Researcher', 'Manager')
);
CREATE TABLE Resource (
resource_id INT PRIMARY KEY AUTO_INCREMENT,
type ENUM('Software', 'Hardware'),
description TEXT
);
]]>
import mysql.connector
db = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="research_system"
)
cursor = db.cursor()
cursor.execute("SELECT * FROM Project WHERE project_id=1")
project = cursor.fetchone()
print(project)
]]>
