最近,一个问题很头疼
有一张usertable
name friends
------------------------------
zhang li
------------------------------
zhang hu
-------------------------------
zhu jie
------------------------------
zhu xiang
--------------------------------
zhu yue
--------------------------------
zhu may
--------------------------------
feng qiang
想用查询语句 怎么变成以下friendstable表啊。
查询出来就可以! name friends friends1 friend2 friend3
----------------------------------------------------------------------
zhang li hu null null
----------------------------------------------------------------------
zhu xiang yue may jie
----------------------------------------------------------------------
feng qiang null null null
----------------------------------------------------------------------
有一张usertable
name friends
------------------------------
zhang li
------------------------------
zhang hu
-------------------------------
zhu jie
------------------------------
zhu xiang
--------------------------------
zhu yue
--------------------------------
zhu may
--------------------------------
feng qiang
想用查询语句 怎么变成以下friendstable表啊。
查询出来就可以! name friends friends1 friend2 friend3
----------------------------------------------------------------------
zhang li hu null null
----------------------------------------------------------------------
zhu xiang yue may jie
----------------------------------------------------------------------
feng qiang null null null
----------------------------------------------------------------------
最大的朋友数-用于创建多少个friend(N)
剩下的用 动态