python mysql保存文件路径

pip install mysql-connector-python

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 插入文件路径
file_path = "/path/to/your/file.txt"
sql = "INSERT INTO files (path) VALUES (%s)"
cursor.execute(sql, (file_path,))
db.commit()

print("文件路径已保存")

# 关闭连接
cursor.close()
db.close()

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 查询文件路径
sql = "SELECT path FROM files WHERE id = %s"
cursor.execute(sql, (1,))  # 假设我们要查询id为1的文件路径
result = cursor.fetchone()

if result:
    print("文件路径:", result[0])
else:
    print("未找到文件路径")

# 关闭连接
cursor.close()
db.close()