数据库保存图片地址

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    url VARCHAR(255) NOT NULL,
    description TEXT
);

import mysql.connector

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

cursor = db.cursor()

# 插入图片地址
sql = "INSERT INTO images (url, description) VALUES (%s, %s)"
val = ("https://example.com/image.jpg", "Example Image")
cursor.execute(sql, val)

db.commit()
cursor.close()
db.close()

import mysql.connector

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

cursor = db.cursor()

# 查询图片地址
sql = "SELECT url FROM images WHERE id = %s"
val = (1,)
cursor.execute(sql, val)

result = cursor.fetchone()
print(result[0])

cursor.close()
db.close()