pip install mysql-python
python
import MySQLdb
conn = MySQLdb.connect(
)
# ...
python
cursor = conn.cursor()
cursor.execute('''CREATE TABLE users (
id INT AUTO_INCREMENT,
name VARCHAR(100),
age INT,
PRIMARY KEY (id))''')
conn.commit()
python
cursor = conn.cursor()
cursor.execute("INSERT INTO users (name, age) VALUES ('John Doe', 25)")
conn.commit()
python
cursor = conn.cursor()
cursor.execute("SELECT * FROM users")
results = cursor.fetchall()
for row in results:
id = row[0]
name = row[1]
age = row[2]
print(f"ID: {id}, Name: {name}, Age: {age}")
python
cursor = conn.cursor()
cursor.execute("UPDATE users SET age = 26 WHERE id = 1")
conn.commit()
python
cursor = conn.cursor()
cursor.execute("DELETE FROM users WHERE id = 1")
conn.commit()
