如何将数据存入mysql数据库

CREATE DATABASE mydatabase;

USE mydatabase;
CREATE TABLE mytable (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

import pymysql

# 建立数据库连接
connection = pymysql.connect(
    host='localhost',
    user='username',
    password='password',
    database='mydatabase'
)

# 创建游标对象
cursor = connection.cursor()

# 执行SQL查询或插入操作
# ...

# 关闭游标和数据库连接
cursor.close()
connection.close()

# 使用参数化查询插入数据
sql = "INSERT INTO mytable (name, age) VALUES (%s, %s)"
data = ("John", 25)
cursor.execute(sql, data)
connection.commit()

# 执行查询语句
sql = "SELECT * FROM mytable"
cursor.execute(sql)

# 获取查询结果
results = cursor.fetchall()

# 处理结果
for row in results:
    print(row)

# 执行更新语句
sql = "UPDATE mytable SET age = %s WHERE name = %s"
data = (30, "John")
cursor.execute(sql, data)
connection.commit()

# 执行删除语句
sql = "DELETE FROM mytable WHERE name = %s"
data = ("John",)
cursor.execute(sql, data)
connection.commit()