CREATE TABLE likes(
user_id INT NOT NULL,
photo_id INT NOT NULL,
created_at TIMESTAMP DEFAULT NOW(),
FOREIGN KEY(user_id) REFERENCES users(id),
FOREIGN KEY(photo_id) REFERENCES photos(id),
PRIMARY KEY(user_id,photo_id)
);
我想不出任何解決方案
uj5u.com熱心網友回復：
您可以使用以下查詢找到最喜歡的圖片
SELECT PHOTO_ID, COUNT(*) AS NO_OF_LIKES
FROM LIKES
GROUP BY PHOTO_ID
ORDER BY NO_OF_LIKES DESC
LIMI 1
您可以使用下面的 having 子句
SELECT PHOTO_ID, COUNT(*) AS NO_OF_LIKES
FROM LIKES
GROUP BY PHOTO_ID
HAVING COUNT(*) = (
SELECT MAX(COUNT(*))
FROM LIKES
GROUP BY PHOTO_ID
)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/533161.html