mysql 查询是否点赞

CREATE TABLE likes (
    user_id INT,
    content_id INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (user_id, content_id)
);

SELECT COUNT(*) > 0 AS is_liked
FROM likes
WHERE user_id = ? AND content_id = ?;

import mysql.connector

def is_liked(user_id, content_id):
    conn = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    cursor = conn.cursor()
    
    query = "SELECT COUNT(*) > 0 AS is_liked FROM likes WHERE user_id = %s AND content_id = %s;"
    cursor.execute(query, (user_id, content_id))
    
    result = cursor.fetchone()
    is_liked = result[0]
    
    cursor.close()
    conn.close()
    
    return is_liked

# 示例调用
user_id = 1
content_id = 100
print(is_liked(user_id, content_id))  # 输出: True 或 False