从mysql查询中获取最后3行时出错

Question

我正在尝试从查询中获取最后3行，但我一直得到以下错误：

SQLSTATE42S21:列已经存在: 1060重复列名'id‘

拜托，我在这里做错什么了？

$sql = "SELECT * FROM (SELECT i.*, m.*, p.* FROM message i JOIN 
members m ON m.id = i.sender_id JOIN profile_photos p 
ON p.member_id = m.id   WHERE (receiver_id = :receive 
AND sender_id = :sent OR receiver_id = :sent AND sender_id = :receive) 
ORDER BY date DESC LIMIT 3) t ORDER BY date ASC";

Answer 1

您可能已经在多个表中有ID列，并选择语句SELECT i.*, m.*, p.*列出它们。

要么选择您想要的特定列

SELECT i.id, i.col1, m.col2, p.col3 ...

或者，使用列别名，如

SELECT i.id as IID, m.*, p.id as PID