且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

MySQL选择同一表中由ID链接的所有行

更新时间:2022-12-12 16:04:32

你必须使用自连接来实现:-

You have to use a self join to achieve this:-

 SELECT T1.Title AS CHILD, T2.Title AS PARENT
 FROM YOUR_TABLE T1, YOUR_TABLE T2
 WHERE T1.PARENT = T2.ID
 AND T1.Title = 'Leaves'