mysql - #1060 - Duplicate column name 'id'

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Why I get #1060 - Duplicate column name 'id'

SELECT COUNT(*) FROM (SELECT * FROM `tips` `t` LEFT JOIN
tip_usage ON tip_usage.tip_id=t.id GROUP BY t.id) sq

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

624 views

1 Answer

深蓝 · Answer 1 · 2021-10-17T02:58:08+0000

answered Oct 17, 2021 by 深蓝 (71.8m points)

Probably because the * in select * selects two columns with the same name from tip_usage and tips.

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…